I want to know what is the correct formula syntax for selecting multiple picklist values? For example `

and(isblank(First_Submitted__c),ISPICKVAL(StageName, "Submitted,Awaiting Recontract,Won Re-Contract"))


The answer lies in using the OR statement with ISPICKVAL. For each picklist value I want to check for I need to seperate with an OR.

and(isblank(Custom_Field_c),OR( (ISPICKVAL(FieldA_c, "Value1")),(ISPICKVAL(FieldA_c, "Value2")),(ISPICKVAL(FieldA_c,"Value3"))))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.