Mark duplicate with cell linking

Nicole Hodges
Nicole Hodges ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics



I am trying to check my helper column if a certain column contains any of the same amounts as in multiple columns in a sep sheet. I tried cell reference in place of [Column Name]@row but it isn't working... any help here?

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