function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Evan KimmeyEvan Kimmey 

Can you have a multi-select picklist that is required only when a one specific option is selected in another standard picklist??

I have two picklists created "Lost To" which just has two standard options and then another field "Competitors" that is multi-select. I want to mandate so that when either option is selected in "Lost To" so that the "Competitors" multi-select field is then required to have at least one entry. 

This is what I tried for a validation rule:
AND(
(OR(ISPICKVAL( Lost_To__c , "Incumbent"),ISPICKVAL( Lost_To__c, "Competitor"))),(AND( ISPICKVAL( Competitor__c ))))
but received the syntax error regardind the limited functions of multi-select picklists. Also to note, changing to a standard picklist isn't an option. 

Any insight is appreciated!
Best Answer chosen by Evan Kimmey
VinayVinay (Salesforce Developers) 
Hi Evan,

Try below  
AND(
(OR(ISPICKVAL( Lost_To__c , "Incumbent"),ISPICKVAL( Lost_To__c , "Competitor"))), ISBLANK(Competitor__c ) )
Hope this helps..

Thanks,
Vinay Kumar

All Answers

VinayVinay (Salesforce Developers) 
Hi Evan,

Try below  
AND(
(OR(ISPICKVAL( Lost_To__c , "Incumbent"),ISPICKVAL( Lost_To__c , "Competitor"))), ISBLANK(Competitor__c ) )
Hope this helps..

Thanks,
Vinay Kumar
This was selected as the best answer
Evan KimmeyEvan Kimmey
This did the trick thank you Vinay!