I have a column of numbers and need to detect if a duplicate is being entered.

palmcitytim

Ideally, Smartsheet would allow me to specify that the data for a cell has to be unique, ie, never used before in the column. Lacking that, I can create an adjacent field, say a check box, that gets checked when a formula detects that the actual data cell just had a duplicate entered. Is this possible?

First time poster!

Thanks folks.

Heather Duff

Hi @palmcitytim ,

Yes! I have done this many times. Let's say the column you're checking for duplicates is called Data. You'll use a checkbox column called Duplicates (or whatever you want it to be called) and here's what your column formula would look like:

=IF(COUNTIF([Data]:[Data],Data@row)>1,1,0)

This translates to: Count the number of times the value in the Data field of this row appears in the Data column. If it appears more than once, check the box; otherwise, leave the box blank.

Let me know if it works for you!

Best,

Heather

Heather Duff

Hi @palmcitytim ,

Yes! I have done this many times. Let's say the column you're checking for duplicates is called Data. You'll use a checkbox column called Duplicates (or whatever you want it to be called) and here's what your column formula would look like:

=IF(COUNTIF([Data]:[Data],Data@row)>1,1,0)

This translates to: Count the number of times the value in the Data field of this row appears in the Data column. If it appears more than once, check the box; otherwise, leave the box blank.

Let me know if it works for you!

Best,

Heather

palmcitytim

Thank you Heather!!!!

Heather Duff

Happy to help!