Identifying Duplicates

Hi -

I've been trying to figure out a way to identify duplicates in my sheet in some way. I'm not picky if that's a checkbox or a flag - it really doesn't matter. I've researched a few formulas through the community and cannot seem to get them to take. I get an #UNPARSEABLE each time.

How do I call out the top 2 ID's as duplicates? There's definitely a step I've missed in following the formulas that are out in the community. Any advice?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!