Finding a duplicate in a column


I have a "name" column and a "HRC code" column and want to find duplicates in each column.

The following formula works just fine for the name column but it wont work for the HRC Code column I believe bc the name of the column has a space. Is there a workaround or do I have to rename the column? (I prefer not)

IF(COUNTIF(Name:Name, Name@row) > 1, "Yes", "No"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!