I need to make a validation rule with picklist. If Picklist value is "Yes" all 3 other custom fields to be populated (cannot be empty). The formula below works only with one of them, does not take all of them, can someone help me with it? Thanks!
AND( ISPICKVAL( Immediate_Relatives__c , "Yes"), ISBLANK(Relative_Full_Name__c)&& ISBLANK( Relationship_to_you__c)&& ISBLANK(Status__c )) Validation rules are in a way the reverse of how we programmers normally think of things.
If the validation rule evaluates to true, the validation trips and prevents the record from being saved. We're not making a rule to determine what is valid, we're making a rule to tell us what is invalid.
So when you say "all 3 fields must not be blank", that translates to "if any of these fields are blank, trip the validation".
In short, you need to be using OR instead of AND when you check for blank fields here.
AND( ISPICKVAL(Immediate_Relatives__c, "Yes"), OR( ISBLANK(Relative_Full_Name__c), ISBLANK(Relationship_to_you__c), ISBLANK(Status__c) ) ) You still need the outermost AND there, which kicks you out of the validation rule when Immediate_Relatives__c is "No"
Your formula is not correct, you are mixing AND() and &&. You should use one or the other but not both:
AND( ISPICKVAL(Immediate_Relatives__c, "Yes"), ISBLANK(Relative_Full_Name__c), ISBLANK(Relationship_to_you__c), ISBLANK(Status__c) ) 