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!


  • Devin Lee
    Devin Lee ✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!