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")
Thanks!
Best Answer
-
Try an IF/COUNTIFS instead:
=IF(COUNTIFS({Main Tracking Email}, @cell = Email@row) = 0, "No", "Yes")
Answers
-
Try an IF/COUNTIFS instead:
=IF(COUNTIFS({Main Tracking Email}, @cell = Email@row) = 0, "No", "Yes")
-
That worked, thank you!
-
Happy to help. 👍️
-
This is great! @Paul Newcome what are you putting in the "@cell" section of the formula?
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!