-1
  • There are 2 dependent picklists: Scenario__c and Platform__c

  • When selecting a picklist value for Scenario__c with anything other than "In-Progress" or "Confirmed"; the picklist Platform__c must have a value selected.

NOT(

   IF(ISPICKVAL(Scenario__c, "In-Progress" || "Confirmed"), 

       ISPICKVAL(Platform__c <> null), ""

      )
)

Error: Syntax error. Missing ')'

1 Answer 1

3

The issue, is that second parameter of ISPICKVAL function should be a String, not Boolean, which is in your case.

AND(
    OR(
        ISPICKVAL(Scenario__c, "In-Progress"),
        ISPICKVAL(Scenario__c, "Confirmed")
    ),
    ISBLANK(TEXT(Platform__c))
)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .