Skip to content
  • Try Smartsheet

    • Smartsheet Basics

    Smartsheet Basics

    Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

    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.

    Thanks

    JD

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • 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)

      image.png

      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

      · Share on FacebookShare on Twitter

    Answers

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending in Smartsheet Basics

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video