Automatically deleting the oldest duplicate in a sheet
Hi,
Just got into SmartSheet as an app and connected it through Zapier to Insightly to automatically update certain things.
I've been trying to have a list of opportunities we have and change it each time it updates.
Realized how to detect duplicates but it either deletes all the duplicates (Meaning the newest, most accurate row as well)
Is there a workaround that lets me delete only duplicates that are older and leaves only the newest one? Adding a "creation" date doesn't work for me since it will only work if there is only 1 update/day.
Thank you!
Radek Homola
Answers
-
Hi @Radek.H,
It looks like a formula to detect the oldest duplicates might be the best solution but, in order to help with that, could you provide some captures of your sheet layout?
Cheers!
Julio
-
@Radek.H My team and I developed a Smartsheet/Zapier integration that will help you with this. You should be able to look up the desired text in a column either from bottom up or top down, and find the oldest entry you are looking for. From there, you could clear or replace the information in the row or Move it to another sheet that acts as an "Archive". If you'd like an invite, sign up here: https://thirddegreeleverage.com/smartsheet
Hope it helps.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!