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!
Help Article Resources
Check out the Formula Handbook template!