Conditional Format Checkmark

DO Target

Hello, I am trying to add conditional formatting to my smartsheet that will checkmark the checkbox column (duplicate TCIN) if there is a duplicate in "TCIN" column.

Please help. I tried adding a help column to identify duplicate with countif formula, then tied the checkbox column to the duplicate, however cannot get the checkmark to be checked. Instead only highlights cell.

Nic Larsen

You could add a column formula to your checkbox column that will check for duplicates:

=IF(COUNTIF(TCIN:TCIN, TCIN@row) > 1, 1)