I want to know when I add a duplicate a same value on a column. How can I do that?
I have an Work Orde column. but usually maybe I repeat a value for make a task under a project line. I need a formula to identificate it and dont have duplicate rows with duplicate info.
Answers

additional i need that the formula ignore the blank spaces, thanks

It looks like you have been working on a formula in this thread, is that correct? https://community.smartsheet.com/discussion/40691/countif#latest
If so, this is the formula Paul helped create for you:
=IF(COUNTIFS([ID Number Column]:[ID Number Column], @cell = [ID Number Column]@row) > 1, 1)
If you wan to ignore any blank ID Number Columns, then you can add another statement at the beginning:
=IF([ID Number Column]@row = "", 0, IF(COUNTIFS([ID Number Column]:[ID Number Column], @cell = [ID Number Column]@row) > 1, 1))
This says that if the ID Number in that row is blank, to keep the box 0, or "unchecked". Then if it's not blank, it will read the rest of your formula. Let me know if this works for you!
Cheers,
Genevieve

thanks works very good. Now i want to copy the formula for the entire column, I mean until 1 row to the final cell of the column, if possible?? and how can i do that ?? thanks again

You can dragfill the formula all the way down the column, see here: https://help.smartsheet.com/articles/2477471dragfill
Or, you can click on row 1's cell, then go to the bottom of the sheet and shift + click the last cell. Then use the keyboard shortcut Ctrl + D (Windows) or Command + D (Mac).
Help Article Resources
Categories
Check out the Formula Handbook template!