Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
cdweaver333cdweaver333 

think I need help with a Validation Rule

We have three email fields: Primary Contract Email, Secondary Contact Email and Tertiary Contact Email.
 
I am trying to establish a validation rule that says if the Secondary Contact Email has a value in it (contains @) then it cannot equal the Primary Contact Email field...Not having much luck though.
 
Any suggestions?  Thanks!
 
 
advlgxpmadvlgxpm
Maybe something like....

 AND(email1 <> '',email2 <> '',email2 = email1)