Workflow - Remove Oldest Modified Versions of Duplicated Rows From Sheet.

Garry K

Hello,

I have two sheets: Sheet A and Sheet B.

I have a workflow set up that copies a row of data from Sheet A to Sheet B based on certain criteria.

Each row in Sheet A has been set-up with a unique identifier.

As part of the workflow, any amends to the row in Sheet A (based on date modified) also transfers to Sheet B.

This leads to duplicated rows in Sheet B.

How can I automatically remove the oldest duplicated rows from Sheet B, retaining the most recent?

Thanks,

Garry

Find more posts tagged with

Accepted answers

All comments

Courtney S.

Hi Garry, I think the answer to this past post also answers your question:

https://community.smartsheet.com/discussion/113493/delete-rows-with-duplicate-data

Definitely test which rows are getting marked duplicate before you make the automation deleting them. Familiarize yourself with the RANKEQ function and If function at the pages below. You may need to change your RANKEQ rank order and IF criteria to have the correct rows marked duplicate and deleted.
https://help.smartsheet.com/function/rankeq

https://help.smartsheet.com/function/if

Garry K

Thanks Courtney

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.