Prevent Duplicates

adp ✭✭
edited 11/14/23 in Formulas and Functions

Hello, I have a column name PO Number for example. This is a text/number column. The value I will enter in this column is unique and should not be repeated. Is there any way to accomplish this? Say I am entering Serial Numbers, and if I enter a repeated serial, or value, can smartsheet block it, or tell me I am entering a duplicate value, or at least mark it as a duplicate? I am planning to enter these values either directly on the sheet or thru a form.

I have read about creating a DUP Column and checkmark, if is dup it will mark it, if it is blank then it will unmark it, can it be done? Putting two formulas for one column?

Thank you very much,


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!