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
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!