function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Michael WinfieldMichael Winfield 

isblank Validation rule with multiple picklist values

I have a validation rule on the 'Interested Modules' picklist that is working below....

text( Interested_Modules__c ) = "Leadr + HR"
&&
 isblank(text(Broker_Status__c) )

However the picklist has grown and I now need to add additional values that if those values are selected, they also fire the validtion rule to fill out Broker Status. I need to add 5 more values. 
Best Answer chosen by Michael Winfield
mukesh guptamukesh gupta
Hi Michael,

Please use below formula:
OR(text( Interested_Modules__c ) = "Leadr + HR", 
text( Interested_Modules__c ) =value1,
text( Interested_Modules__c ) =value2,
text( Interested_Modules__c ) =value3,
text( Interested_Modules__c ) =value4,
text( Interested_Modules__c ) =value5)

if you need any assistanse, Please let me know!!

Kindly mark my solution as the best answer if it helps you.

Thanks
Mukesh

All Answers

VinayVinay (Salesforce Developers) 
Hi Michael,

You can use OR condition for that.

Something like below.
OR(text( Interested_Modules__c ) = "Leadr + HR", Interested_Modules__c=value1,Interested_Modules__c=value2)
Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
mukesh guptamukesh gupta
Hi Michael,

Please use below formula:
OR(text( Interested_Modules__c ) = "Leadr + HR", 
text( Interested_Modules__c ) =value1,
text( Interested_Modules__c ) =value2,
text( Interested_Modules__c ) =value3,
text( Interested_Modules__c ) =value4,
text( Interested_Modules__c ) =value5)

if you need any assistanse, Please let me know!!

Kindly mark my solution as the best answer if it helps you.

Thanks
Mukesh
This was selected as the best answer
Michael WinfieldMichael Winfield
Thanks Mukesh! Worked perfect! Your display of the answer was clear and clean.