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개
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 ))
)
)
