Identify duplicates (w/o DataMesh)

jmo ✭✭✭✭✭✭

Hi team - I have an intake form that my workers are using that asks for their user email.

In the source sheet are some entries that I prefilled out - including some employees and their respective email. Employees that were prefilled in were not to use the intake form.

However, some of those employees decided to use the intake form now I have duplicate entries on the source sheet.

Question: how can I identify duplicates on my source data sheet?

I do not have the DataMesh app on my account.



Best Answer

  • Michael Pappas
    Michael Pappas ✭✭✭✭
    Answer ✓

    I would add another column, and use a COUNTIF function like =COUNTIF([Column 1]:[Column 1],[Column 1]@row). Convert it to a column formula. Then, Sort Rows..., Sort Item By COUNTIF Column, Sort Descending. The duplicates should be at the top of the column.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!