Removing duplicate rows in a sheet

TroyDunn

Would love to see a feature to remove duplicate rows in a sheet. I have an automated rule setup to move rows into a sheet every day and some of the rows are duplicates. I would like to automate the process of removing those duplicate rows.

Paula Cosentino

have a feature that finds duplicates based upon criteria.

Trish Dillon

nice to have a feature to flag duplicate values in column

spauliszyn

Very useful!!! Should also specify if it is the newer modified or older modified line that is deleted.

That could be set up as a workflow automation set either when the new line "comes in" or on a reoccurring schedule.

Char Norman

Completely agree! I created a Duplicate column and added a formula to identify if there is a duplicate in the origin column. But it can only identify if there is more than one.

As spauliszyn mentioned, I need the ability to identify the older origin and remove all newer - keeping the older/initial origin in tact.

Char Norman

https://community.smartsheet.com/discussion/118632/removing-duplicate-rows-in-a-sheet

beckyb

Adding at least a basic remove duplicates command should be easy - it's a basic function in excel. Come on Smartsheet!

NRJW53

Thanks for submitting this idea, I feel like this would be an easy addition for Smartsheet