You need to sign in to do that
Don't have an account?
HNT_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:
Thanks Kevin Lam for the inital VR above http://sforce.co/1GXIt0c
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
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.