Automation

malanto

Hi everyone,

I need to delete duplicate rows in a sheet.

How can I create an automation to delete one of the "n" duplicate rows?

How can I create an automation that deletes a row completely under specific conditions?

Also, is it possible to highlight duplicate rows with conditional formatting?

Thank you!

Find more posts tagged with

Sheets

Automations

Conditional Formatting

Creative

Smartsheet

Accepted answers

All comments

Scott Orsey

Hi, I believe this question has been answered in other threads in the Community so you may want to do a little search.

The basic process would be the following:

1) Create a column with a formula that identifies the duplicate rows. For one approach, see my answer to this question:

https://community.smartsheet.com/discussion/119077/how-to-check-the-duplicate-rows-except-the-first-occurance

2) Use an automation to MOVE the duplicate based on the value that you determined in 1). You cannot delete rows. You can only move them to another sheet. Consider creating a "trash" sheet for this purpose.

3) You can also use conditional formatting to highlight the duplicate rows.

Hope this helps.

Be well

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.