Skip to main content
Lynda CS (State of Michigan) 님이 #Customer Service에 질문했습니다
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일 오후 7: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

    )

    )