Handling Duplicates

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

Find more posts tagged with

Accepted answers

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

All comments

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! :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.