Need to return true (1) for these scenarios:
- When the picklist value of Picklist 1 is 1, 2, or 3, or
- When the picklist value of Picklist 1 is 4 and the picklist value of picklist 2 is either A, B or C
I tried multiple configurations of workflow rules and additional fields, and my checkbox formula with a Case statement that's for just scenario 1 works great with the workflow rules I ended up with.
But when I changed the checkbox formula to add scenario 2, am getting the dreaded error "Field Hearing_Type_Picklist__c is a picklist field. Picklist fields are only supported in certain functions".
This is my formula:
IF(TEXT(Picklist_1 = "1", 1, IF(TEXT(Picklist_1 = "2", 1, IF(TEXT(Picklist_1 = "3", 1, IF(AND(TEXT(Picklist_1 = "4", Picklist_2 = "A", 1, IF(AND(TEXT(Picklist_1 = "4", Picklist_2 = "B", 1, IF(AND(TEXT(Picklist_1 = "4", Picklist_2 = "C"), 1, 0))))))))))))))
I've tried many different changes and rewrites to get it to pass the syntax check, but no luck.
What does it want from me?
Thank you for any suggestions!
Try this =
OR(
CASE(
Picklist_1__c,
"1", 1,
"2", 1,
"3", 1,
0
) = 1,
AND(
TEXT(Picklist_1__c) = "4",
CASE(
Picklist_2__c,
"A", 1,
"B", 1,
"C", 1,
0
) = 1
)
)