Hello, I wrote a validation rule to make these two picklist field (Complaint reason & complaint level) required when a checkbox field (ACI Complaint) is true? Formula - And( ACI_Complaint__c=True, ISBLANK(TEXT( Complaint_Reason__c )), ISBLANK(TEXT( Complaint_Level__c )) ) However, if one of either of the field (Complaint reason & complaint level) is filled, I am able to save without filling the other. I am wanting to update/change the rule in such that I will need to fill both fields and not just one in other to save. Please advise
5 respuestas
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi Anthony,
You'll need an OR between your ISPICKVALs. Also, no need for "= true" for a checkbox:
AND(ACI_Complaint__c,
OR(
ISBLANK(TEXT( Complaint_Reason__c )),
ISBLANK(TEXT( Complaint_Level__c ))
)
)
