Duplicates formula

edited 03/25/24 in Formulas and Functions

Hello I'm trying to find duplicates in the "Rest" column but since there are a few rows with blank spaces I'm getting a ✔ in the checkbox "duplicate column" the formula that I used is :

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

Thank you

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!