Check box on Sheet if Name on one is same, and reviewer is the same.

I figured out the 2 separate functions. I am trying to check a box on Peer Review Master if the Employee to be Reviewed shows that a review has been submitted on the Peer Revie]w Submitted Sheet where the #1 Email from Peer REview Master matches the Reviewer Email from the Peer Reviews Submitted:

From Peer Review Master:

Employee to be Reviewed #1 Email #1 Complete

From Peer Review Submitted:

I figured out the 2 separate functions but can't figure out how to put together.

To find if Reviewer from column #1email on Master is on Submitted: =IF([#1 Email]@row, {360 Peer Reviews Submitted Range 3}

To find Employee to be reviewed on Peer Review Master is on Peer Review submitted; =CONTAINS([Employee to be Reviewed]@row, {360 Peer Reviews Submitted Range 2})

Thank you in advance!!

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Debbie Petersen

What about doing a COUNTIFS formula to COUNT how many rows in your source sheet have the same Email and Employee. Then if the COUNT is greater-than or equal-to 1, you can check the box.

Try something like this:

=IF(COUNTIFS({360 Peer Reviews Submitted Range 3}, [#1 Email]@row, {360 Peer Reviews Submitted Range 2}, [Employee to be Reviewed]@row) >=1, 1, 0)

Let me know if this works for you.

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Debbie Petersen

What about doing a COUNTIFS formula to COUNT how many rows in your source sheet have the same Email and Employee. Then if the COUNT is greater-than or equal-to 1, you can check the box.

Try something like this:

=IF(COUNTIFS({360 Peer Reviews Submitted Range 3}, [#1 Email]@row, {360 Peer Reviews Submitted Range 2}, [Employee to be Reviewed]@row) >=1, 1, 0)

Let me know if this works for you.

Cheers,

Genevieve

Debbie Petersen

Thank you Genevieve - I will try that out now and report back!

Debbie Petersen

THANK YOU! Works like a dream!!!

Genevieve P.

Wonderful! I'm glad I could help. 🙂

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.