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
LakisLakis 

Picklist validation rules on Contact

Hey guys, I'm trying to put a validation rule on Contact to ensure that at least one of the three picklists have a value before saving.

Tried ISNULL, ISBLANK and no luck. Can anyone point me to the right direction please?

Thanks in advance,
​Lakis
Best Answer chosen by Lakis
LakisLakis
I've worked this out with the following:

AND( 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c , "Blacklisted / Bad Debt")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c , "Influencer")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c , "In Hand")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Leader")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Must / Star")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Not Relevant")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"One to Watch")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c , "Relevant")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Specialist")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Suspect")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Wait List")), 
NOT (ISPICKVAL( PURE_Importance_contact__c , "Influencer")), 
NOT (ISPICKVAL( PURE_Importance_contact__c , "In Hand")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Leader")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Must / Star")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Not Relevant")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"One to Watch")), 
NOT (ISPICKVAL( PURE_Importance_contact__c , "Relevant")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Specialist")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Suspect")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Wait List")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c , "Influencer")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c , "In Hand")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Leader")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Must / Star")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Not Relevant")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"One to Watch")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c , "Relevant")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Specialist")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Suspect")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Wait List")))

All Answers

JustAGirlyGeekJustAGirlyGeek
Can you post what you have so far?
LakisLakis
I've worked this out with the following:

AND( 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c , "Blacklisted / Bad Debt")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c , "Influencer")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c , "In Hand")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Leader")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Must / Star")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Not Relevant")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"One to Watch")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c , "Relevant")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Specialist")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Suspect")), 
NOT (ISPICKVAL( LE_Miami_Importance_contacts__c ,"Wait List")), 
NOT (ISPICKVAL( PURE_Importance_contact__c , "Influencer")), 
NOT (ISPICKVAL( PURE_Importance_contact__c , "In Hand")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Leader")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Must / Star")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Not Relevant")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"One to Watch")), 
NOT (ISPICKVAL( PURE_Importance_contact__c , "Relevant")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Specialist")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Suspect")), 
NOT (ISPICKVAL( PURE_Importance_contact__c ,"Wait List")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c , "Influencer")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c , "In Hand")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Leader")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Must / Star")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Not Relevant")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"One to Watch")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c , "Relevant")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Specialist")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Suspect")), 
NOT (ISPICKVAL( We_Are_Africa_Importance_contact__c ,"Wait List")))
This was selected as the best answer
JustAGirlyGeekJustAGirlyGeek
Give this a shot:

AND(
ISBLANK(TEXT(LE_Miami_Importance_contacts__c)),
ISBLANK(TEXT(PURE_Importance_contact__c)),
ISBLANK(TEXT(We_Are_Africa_Importance_contact__c))
)
LakisLakis
Thanks but ISBLANK doesn't work with picklists. Besides the above solved my problem already. Thanks for looking into this for me ;)

Cheers,
L
JustAGirlyGeekJustAGirlyGeek
Happy to help. Btw, ISBLANK will work if used in conjunction with the TEXT function like in my example. Just keep in mind if you use the pick list values you will need to maintain that VR everytime you update/add new values in your 3 pick list fields.
LakisLakis
Great, thanks for the tip. Will keep this in mind.