Automatically deleting the oldest duplicate in a sheet

Options
Radek.H
Radek.H
edited 01/20/23 in Formulas and Functions

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

  • Julio S.
    Julio S. Moderator
    Options

    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

  • RossNovotny
    Options

    @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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!