most recent instance of a dropdown option


I'm new to Smartsheet, but I've been learning! I'm building out an inventory system and am having a little trouble conceptualizing a needed aspect. I have devices organized into kits. I've made a new sheet with a form to track whenever an employee physically verifies the contents of a kit. To simplify, let's say column 1 is a dropdown with kit options (Kit Alpha, Kit Bravo, Kit Charlie, etc), column 2 is a date column, and column 3 is the contact of whomever did the inspection (this data is collected via a form).

I would like to show on a dashboard or report a list of the most recent date of inspection along with who completed the inspection for EACH kit.

Any help would be appreciated, tia!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!