Handling Duplicates

edited 02/09/21 in Smartsheet Basics

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.



Best Answer

  • Sean Morgan
    Sean Morgan Employee
    Answer ✓

    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!