How to find duplicates in the document name column?

Umar Farooq

There are more than 700 documents and I want to find duplicate rows, I am new to Smartsheet.

Paul Newcome

Try this in a checkbox or flag type column:

=IF(COUNTIFS([Document Name]:[Document Name], @cell = [Document Name]@row)> 1, 1)

Paul Newcome

Try this in a checkbox or flag type column:

=IF(COUNTIFS([Document Name]:[Document Name], @cell = [Document Name]@row)> 1, 1)