Duplicates based on Doc ID and Date

I am trying to write a formula that will checkmark a box if 1 cell matches any other cell in the same column and they both have empty dates cells. I keep getting an unparsable error. I only want to see if there is a duplicate request in cell 1 if they haven't been completed. Empty dates means we are still working the document.

This one works and shows me if there is a duplicate "request" but does not include the date data.

=IF(COUNTIF([Document ID # @]:[Document ID # @], [Document ID # @]@row) > 1, 1)

However, I have no idea how to tell it to check if the two duplicates are in working status.

Find more posts tagged with

Accepted answers

Paul Newcome

It is going to be very similar to this, but you need a COUNTIFS (with the "S" on the end) instead.

=IF(COUNTIFS([Document ID # @]:[Document ID # @], [Document ID # @]@row, [Date Column]:[Date Column], @cell = "") > 1, 1)

All comments

Paul Newcome

It is going to be very similar to this, but you need a COUNTIFS (with the "S" on the end) instead.

=IF(COUNTIFS([Document ID # @]:[Document ID # @], [Document ID # @]@row, [Date Column]:[Date Column], @cell = "") > 1, 1)

Aubrey Jones

Thank you!

Paul Newcome

Happy to 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.