Handling Duplicates

joseph.delai50256

Bula (Hello)

what is the best way to handle duplicates in a smartsheet grid?

conditional formatting seems to come to mind, however, what if we have a scheduled import of data, e.g. via DataUploader or MS Power Automate? we haven't found any methods or features there to handle Updates or Duplicates.

looking for any other better way to handle this problem of duplicates.

Thanks

JD

Sean Morgan

Hello @Janelle Alexander & @joseph.delai50256 ,

You can identify duplicates by using a IF/COUNTIF Formula, combined with a Checkbox or Flag column as such:

=IF(COUNTIF([Column Range to Check]:[Column Range to Check], ValueToSearchFor@row)

In the above example, I used: =IF(COUNTIF([Column4]:[Column4], [Column4]@row) > 1, 1, 0)

Please note that if I were to make this into a Column Formula, it would check every row that has the number 1.

Let me know if you have any questions!

Regards

Sean

David Tutwiler

Do you want to notify about them or automatically remove them?

Janelle Alexander

I have this same question, and I am looking for a way to identify duplicates easily.

Thank you!

Sean Morgan

Hello @Janelle Alexander & @joseph.delai50256 ,

You can identify duplicates by using a IF/COUNTIF Formula, combined with a Checkbox or Flag column as such:

=IF(COUNTIF([Column Range to Check]:[Column Range to Check], ValueToSearchFor@row)

In the above example, I used: =IF(COUNTIF([Column4]:[Column4], [Column4]@row) > 1, 1, 0)

Please note that if I were to make this into a Column Formula, it would check every row that has the number 1.

Let me know if you have any questions!

Regards

Sean

Janelle Alexander

Thank you, @Sean Morgan! That works! :)