IF duplicate AND a condition is met, then Check Box

I need to create a formula that will check a box if there is a duplicate in one column and in the same row a condition is met.

The duplicate would patient MRN and the condition in would be "Referred".

If the MRN is a duplicate and only if "Referred" is selected for both rows would the checkbox be checked on both rows.

If the MRN is a duplicate, but one row is "Referred" and the other row is "Not Referred" then no checkbox.

Thank you for the help!!

Find more posts tagged with

Accepted answers

Carson Penticuff

You will need to adjust the column names to match your sheet, but other than that, this should get you where you need to go:

=IF(COUNTIFS([Patient MRN]:[Patient MRN], [Patient MRN]@row, [Referred Column]:[Referred Column], "Referred") > 1, 1, 0)

All comments

Carson Penticuff

You will need to adjust the column names to match your sheet, but other than that, this should get you where you need to go:

=IF(COUNTIFS([Patient MRN]:[Patient MRN], [Patient MRN]@row, [Referred Column]:[Referred Column], "Referred") > 1, 1, 0)

mgsmith

Thank you! This worked!

Carson Penticuff

I'm glad it worked for you! 👍

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.