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
Akshay JuwaAkshay Juwa 

Validation rule when certain criteria is met!!

Hello Group,

I'm new to this but I was wondering if anybody could help me with a validation rule for the following.
  
 
FieldMinor Beneficiary
CriteriaStatus = Preparation
Minor Beneficary is not null
 Minor Beneficiary DOB is blank
 Minor Beneficiary SSN is blank
 Minor Beneficiary Address is Blank
 Age of Majority is blank
 so if these criteria are true it would diplay an error.
VinayVinay (Salesforce Developers) 
Hi Akshay,

You can try below validation and make sure you use right API names of fields. 
AND(ISPICKVAL(Status, 'Preparation' ), 
MinorBeneficary!=NULL, ISBLANK(Minor Beneficiary DOB),ISBLANK(Minor Beneficiary SSN),
ISBLANK(Minor Beneficiary Address),
ISBLANK(Age of Majority)
)

Please mark as Best Answer if above information was helpful.

Thanks,
prabhakar Thummojiprabhakar Thummoji

Hi Akshay,

You can refer the below validation rule for your requirement, it may helpful for you to resolve the issue.
You have to use 3 Functions here AND,ISPICKVAL and ISBLANK based on your requirement.

Validation rule you need to give as below:
AND(ISPICKVAL(Status, 'Preparation'),
                Minor Beneficary != NULL,
                 ISBLANK(Minor Beneficiary DOB),  
                 ISBLANK(Minor Beneficiary SSN),
                 ISBLANK(Minor Beneficiary Address),
                 ISBLANK(Age of Majority)
                )

Please mark as Best Answer if above information was helpful.
Regards,
Prabhakar.T