Checking for Duplicates and then Checking for the highest ID Code.

Hi there!

We use Smart Sheet for tracking multiple components of our department. On one sheet, I want a formula to check for duplicate names and then look at the ID Code Column and I want a box to be checked for any ID Code that isn't the highest of the duplicates.

I have gotten the first part of the formula to work. I have a column where the box is checked if there is a duplicate name. I use the formula below:

=IF(COUNTIF([Contractor Name]:[Contractor Name], [Contractor Name]@row) > 1, 1, 0)

I can't get the second part of the formula to work in where it then looks at the ID Code and does not check the box for the highest ID Code.

Any suggestions would be appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!