Check box behavior

Jayashree Lakshmanan

I need a formula to:

if document number column is a duplicate entry then the checkbox needs to be checked and if the document number is blank or a non-duplicate value then unchecked- can Smartsheet do this?

Paul Newcome

Try something like this...

=IF(AND([Document Number]@row <> "", COUNTIFS([Document Number]:[Document Number], [Document Number]@row) > 1), 1)

Paul Newcome

Try something like this...

=IF(AND([Document Number]@row <> "", COUNTIFS([Document Number]:[Document Number], [Document Number]@row) > 1), 1)

Jayashree Lakshmanan

This worked! Thanks a lot Paul!!!

Paul Newcome

Happy to help. 👍️