Function for finding duplicate entries?
Hello, I am fairly new to Smartsheet but slowly learning all the basics. The Languages Program I work for uses Smartsheet to gather (via forms) student registrations. At times we have duplicate student registrations and manually it can take some time to find them (as there are over 3000 students). Is there a way or a function for Smartsheet to highlight (maybe by conditional formatting?)/show the duplicate registrations so that I can consolidate the two registrations received into one row, and delete the other entry? Thank you in advance!
Answers
-
Create a column with a COUNTIF pointed towards a unique ID column (Might be name or a number specific to each student). Than set a conditional formatting rule to highlight any row where that count is higher than you want it to be.
Examples and some images to help you navigate below
=COUNTIF(Name:Name, Name@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!