Finding duplicate values in a column only on certain responses

Hello,

I want to look for duplicates in a column but only on certain cell values in the column.

In this case, any cell in the column that has the number 59 in it I want to be evaluated to see if there is a duplicate in the same column and then return a true to my check box column type. I can get this to work when I look for duplicates and eliminate blank cells, but can't seem to change to formula to only evaluate at cells with the number 59 as part of the value.


=IF(COUNTIFS([On Site Desk]:[On Site Desk], [On Site Desk]@row, [On Site Desk]:[On Site Desk], CONTAINS("59"(@cell))) > 1, 1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!