Compare Contact Column vs Email contact Column

I am using the proof info columns, and sadly they only return the contact email. I want to compare this to a "Reviewer #1" contact column to see if everyone in the Reviewer #1 column has approved, I tried the following formula:

=IF(CONTAINS([Reviewer #1]@row, [Approved By]@row), 1, 0)

and it did not work.

Any thoughts? (Only using core app)

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You will need to create a table that has each person's name in one column and email in another column. Then you can use a formula such as an INDEX/MATCH to pull the email over based on the name in the contact column. Once that is done, then you can do your comparison.

All comments

Paul Newcome

Does [Reviewer #1] contain emails as well, or does it list the names?

rbrice

@Paul Newcome It only lists the names since everyone is added in as contacts

Paul Newcome

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.