Duplicate Checkbox Column

jordanlamagna

I've been perusing the forums for how to have a checkbox column check a duplicate of a row and I can't get any of them to work the way I want them to.

Criteria for checkbox being checked:

• Row ID shows up more than once AND
• Created column is not the most recent

Once I get this figured out, I will have an automation where the rows with checkboxes checked are moved to an archive sheet. Therefore, I want the most recent version of a Row ID to stay unchecked, therefore staying on this sheet. In the screenshot below, I've shown which box would be checked.

Thank you for your help!

Paul Newcome

Try this:

=IF(Created@row <> MAX(COLLECT(Created:Created, [Row ID]:[Row ID], @cell = [Row ID]@row)), 1)

Paul Newcome

Try this:

=IF(Created@row <> MAX(COLLECT(Created:Created, [Row ID]:[Row ID], @cell = [Row ID]@row)), 1)