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 件の回答
  1. 2017年11月7日 19:23

    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

    )

    )