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

Options
Garry K
Garry K ✭✭
edited 06/05/24 in Smartsheet Basics

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

Answers