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!

Find more posts tagged with

Accepted answers

Paul Newcome

Try an IF/COUNTIFS instead:

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

All comments

Paul Newcome

Try an IF/COUNTIFS instead:

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

swirt009

That worked, thank you!

Paul Newcome

Happy to help. 👍️

JayCee

This is great! @Paul Newcome what are you putting in the "@cell" section of the formula?

Paul Newcome

@JayCee You would just leave it as is. Here is more information on @row and @cell.

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell#toc-use-cell-to-perform-smarter-cell-calculations

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.