I need help with the following Multi-Select Picklist Validation - Answers - Salesforce Trailblazer Community
Ask Search:
Dawn BublitzDawn Bublitz 

I need help with the following Multi-Select Picklist Validation

I am trying have a field become required for adding in text if the Multip Select value Other is picked. It keep getting an error message. Please help


AND(         ISBLANK(QC_Other_Exception_Description__c),         ISPICKVAL(QC_Exceptions__c,"Other") )
Best Answer chosen by Dawn Bublitz
Ahilesh RagavanAhilesh Ragavan
Like this:
AND(         
ISBLANK(QC_Other_Exception_Description__c),         
INCLUDES(QC_Exceptions__c,"Other") 
)

 

All Answers

Ahilesh RagavanAhilesh Ragavan
Like this:
AND(         
ISBLANK(QC_Other_Exception_Description__c),         
INCLUDES(QC_Exceptions__c,"Other") 
)

 
This was selected as the best answer
Dawn BublitzDawn Bublitz
Thank you Ahilesh! this worked with no error messages 
Mohammadsohail PatelMohammadsohail Patel
Hi Dawn,

Try this:
 
AND(         
ISCHNAGED(QC_Exceptions__c),
ISBLANK(QC_Other_Exception_Description__c),         
INCLUDES(QC_Exceptions__c,"Other") 
)