Identifying and Archiving Duplicate Rows While Retaining the Oldest Entry
I require help in detecting duplicate rows and transferring them to an archive sheet while retaining the oldest entry. Your assistance is highly valued. Thank you!
Answers
-
Assuming your column ID is an autonumber column here. You can use a formula in your duplicate checkbox column to see if an individual row is the smallest ID for that Ticket number.
=IF(MIN(COLLECT(ID:ID, Ticket:Ticket, Ticket@row)) = ID@row, 0, 1)
This will check the box for ONLY duplicates.
Separately, you can set up a Move Row automation with "When a date is reached" as trigger (and set up as a reasonable cadence for your use case), with "Duplicate Is Checked" as a condition.
—
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" buttons are much appreciated. Thanks!If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Thanks Kerry. Yes the column ID is an autonumber column.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives