Compare duplicate rows, identify most recently added

I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date is extended. I'd like to identify the oldest added duplicate to the sheet so that I can create a workflow to move it to my archive sheet. Thank you.

Screenshot 2023-08-25 at 11.08.09 AM.png


Best Answer

  • Carson Penticuff
    Carson Penticuff Community Champion
    Answer βœ“

    This should work with only one caveat... if multiple entries have the same date and time (down to the minute), they will not be marked as duplicates.

    =IF(AND([Created]@row <> "", NOT([Created]@row = MAX(COLLECT(Created:Created, ID:ID, ID@row)))), 1, 0)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!