How to Return Many Values to Track Status Changes

We are trying to track the dates that tickets change from status to status. Using workflow, I created a new line added for each status change. But now need to return the dates on each of those lines entered. Below are screen shots of the two sheets I am trying to do this. Tried Vlookup, Match and Index but cant get them to work together correctly.

You will see the highlighted example where I am trying to pull the Open Date and Corrected Date.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!