Finding Duplicate rows then comparing Create Dates
I'm trying to develop a simple system for people to create new Smartsheet rows with a form with two fields.
An order can move from location to location in our facility so the idea is the user who moves the order completes the form with the two fields and submits
I want to be able to find duplicate order numbers (which i have found the solution with a checkbox)...
=IF(COUNTIF([Order Number]:[Order Number], [Order Number]1) > 1, 1)
and then compare the two CREATED ON dates.. then archive the oldest one to another sheet.
Essentially I'd like to automate the archive/deleting of the oldest row.
I'm having trouble figuring out a way to compare the dates on the found duplicated rows.
Thanks for any suggestions