How to catch duplicate data using formulas or premium apps?

Hi, Good day!

I need help in catching this duplicate data with the same Service Type and Last Name but the First Name is different because the first one has middle initial. Can this be caught by sort of using formula or premium apps like datamesh? Anyone have a great mind or idea how to make a new column and formulas then labeled them as "Duplicate"?.

Thanks in advanced!

@Paul Newcome

@Andrée Starå


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!