+ Start a Discussion
Rung41Rung41 

Task Status Validation on Multi-Select fields

I'm looking for validation rule to prevent two Multi-Select fields (Accomplished__c & Next_Steps__c) from being populated unless the Task staus is set to "Completed". This is how far I have gotten but not sure how to indicate the two multi-select fields need to be blank or if my current logic is correct so far.

AND(
NOT(ISPICKVAL(Status,"Completed")),
Best Answer chosen by Rung41
Rung41Rung41

I think I got it but I will need to tesk more. 

AND(
NOT(ISPICKVAL(Status,"Completed")),
NOT(ISNULL(Accomplished__c)))

All Answers

Nayana KNayana K
AND(
NOT(ISPICKVAL(Status,"Completed")), TEXT(Accomplished__c) != "",TEXT(Next_Steps__c) != "")




I am not sure whether this will work. You can give a try

 
Rung41Rung41
Unfortnuately, no. I get the following error Field Accomplished__c is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions
Rung41Rung41

I think I got it but I will need to tesk more. 

AND(
NOT(ISPICKVAL(Status,"Completed")),
NOT(ISNULL(Accomplished__c)))

This was selected as the best answer