How to get the latest update of primary column using Modified Date/time

Avinash DN
Avinash DN ✭✭
edited 07/19/23 in Formulas and Functions

I have a form which will be filled by store managers, The unique (primary key) is the Store No and few columns after that. 1 store will submit multiple forms in a week. I need only the latest entry of each store (Distinct Store No) of all the stores.

In my example below, I need only rows 2 and 3 to be shown. row 1 is duplicate of row 3 with old / earlier modified date.

Appreciate your help in advance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!