Finding Duplicate User IDs in one column

Hello Smartsheet community,

I'm trying to identify duplicate User IDs in the same column and in the same sheet. The typical user ID has 6 numbers in it (example: 100054). We are working with around 10k user ids.

We've tried this formula: =IF(COUNTIF([User - Employee ID]:[User - Employee ID], [User - Employee ID]@row) > 1, 1, 0), but it didn't work. Additionally, we tried around 10 other formula versions that we found by searching the community to no avail. The helper column with the check box never checked any number, even though we confirmed there are duplicates through the "sort" feature.

Thanks,

Emily

Find more posts tagged with

Human Resources

Formulas

Automations

Accepted answers

Mark Cronk

Try:

=IF(COUNTIF([User - Employee ID]:[User - Employee ID], @cell=[User - Employee ID]@row) > 1, 1, 0)

Work?

Mark

All comments

Mark Cronk

Try:

=IF(COUNTIF([User - Employee ID]:[User - Employee ID], @cell=[User - Employee ID]@row) > 1, 1, 0)

Work?

Mark

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.