Flagging Duplicate Values

bmccaslin

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.

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

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!