Find duplicates based on multiple criteria


Hello everyone,

I need some help with correct formula to find out duplicates. Is there a way to find duplicate records if case number, client's name, from date, and to date are the same? The first and last records are duplicate but how do I set up a correct formula? I currently only have case number and name columns in my formula but not dates.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!