How do I create an email confirmation?

Kitty

How do I set up a "red flag" if the email that is entered second does not match the first entry?

Laura McDonald

I have a checkbox column set up with the below formula, which will display a red flag if the email entered in "Employee 1" column DOES match the email entered in Employee 2 column. You could probably manipulate this formula to work in the opposite way, so that if flags when they don't match, to meet your needs?

=IF([Employee 1]@row = "", 0, IF([Employee 1]@row = [Employee 2]@row, 1))

Laura McDonald

I have a checkbox column set up with the below formula, which will display a red flag if the email entered in "Employee 1" column DOES match the email entered in Employee 2 column. You could probably manipulate this formula to work in the opposite way, so that if flags when they don't match, to meet your needs?

=IF([Employee 1]@row = "", 0, IF([Employee 1]@row = [Employee 2]@row, 1))

Kitty

It works! Thank you so much!

Kitty Sandel