Linking Most Recent Status from Another Sheet

I'm trying to set up a ticket system and having a little trouble figuring out how to accomplish my goal.

Technicians have their own sheets and forms to submit updates on their tickets. Multiple techs can work on the same ticket ID. Their form submissions get copied to a master form. A simple vlookup to match the ticket # with the status doesn't work as they don't necessarily get copied in the correct order.


Here's the simple vlookup results.

And here is the Master list it is pulling from.

Seems as if the vlookup pulls from the bottom of the sheet, which would not be a problem except for the fact that my technicians aren't always timely in their submissions and sometimes backdate.


I've read a little about Collect and MIN but am unsure of how to connect it to the ticket number.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!