+ Start a Discussion
HNT_NeoHNT_Neo 

Picklist to drive 1 of 3 multi-picklists

Looking for a Validation Rule when a picklist value is selected, 1 of 3 multipicklist fields must have a selection but if all 3 of the Multipicklist fields are left blank when user selects Save, user to receive an error, on all 3 Multi-picklist fields . 

Picklist API Name: Staged
Picklist value: Completed

#1 MultiPicklist API Name: Competition
#2 Multi-Picklist API Name: Moving
#3 Multi-Picklist API Name: Going

Here is what's been created so far to work on a single Multi-Picklist field when left blank:
 
AND(ISPICKVAL(Stage, "Completed"), ISBLANK(Competition__c))

Thanks Kevin Lam for the inital VR above http://sforce.co/1GXIt0c 
Mrunali GaonkarMrunali Gaonkar
Hi,

AND(ISPICKVAL(Stage, "Completed"), ISBLANK(Competition__c) && ISBLANK(Moving__c) && ISBLANK(Going__c))
If picklist value is selected, 1 of 3 multipicklist fields must have a selection but if all 3 of the Multipicklist fields are left blank It will give error..
Error Location will be on top of the page.