function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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)