Identifying Duplication in a Column - New Form Submissions
Hello,
I am trying to see if there is a formula I could use in a hidden column, with a checkbox, where when a new form is submitted (and a new line is then entered onto a sheet) it would alert me if there was a duplication in a certain column.
Example: We enter new sales orders into Smartsheets using a form. If an order number is submitted twice, the box on each line where the instance occurs would be checked and then I could set up conditional formatting to highlight the two lines. I can get this to work once, but not when a new line is added to the sheet.
Hopefully this makes sense, appreciate any help!
Thank you,
Allison
Comments
-
You should be able to use something along the lines of...
=IF(COUNTIFS([Order Number]:[Order Number], [Order Number]@row) > 1, 1)
This will check the box if it finds the order number more than once. It should also be auto-filled into new rows as more forms are submitted.
-
Ah, I was so close - missing the "@row"! Thank you very much for your help, Paul! Works flawlessly and has solved our dilemma - appreciate it!!!
Have a great week!
Allison
-
No worries. Happy to help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!