If Email@Row matches an email on a different sheet, display "yes"

Hi All,

I'm hoping for some help!

I have two sheets, "Program Planning Guide Submission" and "Main Tracking" both contain email addresses.

I need a formula for when someone is added to the "Program Planning Guide Submission" sheet, a column checks if the email is already on the "Main Tracking" sheet. If it is, the column should display "Yes", if not, the column should display "No".

This is the formula I tried and all results display "No" even though I know some emails are matching.

=IFERROR(IF(MATCH(Email@row, {Main Tracking Email}, 0), "Yes"), "No")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!