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

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