How to Return Many Values to Track Status Changes

jasonp

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.

Andrée Starå

Hi Jason,

Have a look at the post below where i describe a method I developed that you maybe could use.

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

jasonp

We are trying not be introduce another tool/application to the environment. Any other options?

Andrée Starå

@jasonp

My solution is all in Smartsheet, just using another sheet for the process.

Make sense?

Would that work?