Flagging Duplicate Values

Searching through community I found a way to have flags for duplicate values - however, it seems that this formula is not working as I'd hope.

=IF(COUNTIFS(SKU:SKU, SKU@row) > 1, 1)

I don't get an error - it just doesn't check the box. As you can see, there IS a duplicate value in SKU.

Find more posts tagged with

Accepted answers

Ray Lindstrom

Hi @bmccaslin,

I recreated and tested, and found this to work:

=IF(COUNTIF(SKU:SKU, @cell = SKU@row) > 1, 1, 0)

Hope this helps!

BRgds,

-Ray

All comments

bmccaslin

Looks like the duplicates are working, but NOT where I have a leading 0. How do I get these to work as well?

bmccaslin

Based off another forum - I've modified my formula to this:

=IF(COUNTIF(SKU$1:SKU@row, @cell = SKU@row) > 1, 1, 0)

Which DOES allow for the leading 0 to be accounted for (because SmartSheet adds a ' before the 0 to make it text). Now though, I cannot make the formula a column formula. States that the syntax is not quite right. Help!!!

Ray Lindstrom

Hi @bmccaslin,

I recreated and tested, and found this to work:

=IF(COUNTIF(SKU:SKU, @cell = SKU@row) > 1, 1, 0)

Hope this helps!

BRgds,

-Ray

bmccaslin

Ah that worked!!! And I was able to convert to a column formula. Awesome!! Thank you much!

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