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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!