+ Start a Discussion
CRMFanReneeCRMFanRenee 

Help with Simple validation rule

I need to write a validation rule that if email or phone is blank give an error message. Meaning one or the other need's to be filled in. Can someone please help, thanks

Best Answer chosen by Admin (Salesforce Developers) 
ShaliniShalini

Hi,

 

Try the below code, it should work

AND(LEN(Phone)=0,LEN(Email)=0)

Message Edited by Shalini on 06-01-2009 11:58 PM

All Answers

werewolfwerewolf

Have you tried something as simple as

 

AND(Email="", Phone="")

 

 

ShaliniShalini

Hi,

 

Try the below code, it should work

AND(LEN(Phone)=0,LEN(Email)=0)

Message Edited by Shalini on 06-01-2009 11:58 PM
This was selected as the best answer