Hi Steve :)
I'm having issues with a Validation Rule based on Contact Type. I want if the Contact Type is "Physician" OR "Non-Physician Practitioner" is chosen, then the picklist field called "Credential" must have MD, DO, ARNP, PA or DPT selected. Can you help?:) I've tried most ways that I know and cannot get it right for some reason. Thank you, in advance for your help!!
4 comentarios
You missed the second 1 result on "Non-Physician Practitioner"
AND(
CASE(Contact_Type__c, "Physician",1,
"Non-Physician Practitioner", 1,
0) = 1,
CASE(Credential__c,
"MD",1,
"DO",1,
"ARNP",1,
"PA",1,
"DPT",1,
0)= 0
)
