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

Find more posts tagged with

Accepted answers

All comments

Julio S.

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

@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.

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