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

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.

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    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:


    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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!