Compare Contact Column vs Email contact Column

rbrice

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)

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.

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

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.