Duplicate Checkbox Column

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!

Find more posts tagged with

Countif

IF(

duplicates

Accepted answers

Paul Newcome

Try this:

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

All comments

Paul Newcome

Try this:

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

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.