Skip to main content
I'm working on a checkbox formula the result of which is then used in 2 workflow rules to check or uncheck a checkbox on a page layout.

 

Need to return true (1) for these scenarios:

  1. When the picklist value of Picklist 1 is 1, 2, or 3, or 
  2. 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!
4 个回答