Duplicates based on Doc ID and Date

Aubrey Jones

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.

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)

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. 👍️