Looking for a way to capture the turnaround time for new requests

Jake Gustafson

I have a scenario where we have an SLA of 24 hours. I can capture the submission time of requests with the Auto-Numbering/System Generated (Created Date). That gives me the exact Date/Time Stamp of the submission. Now the clock is ticking. However, on the backend is where I'm struggling. I tried the Record a Date automation when the Status field is updated to Completed, but that only provides a Date, so things calculate to 0 because it is less than a day turnaround generally. Now what I have in place is the Auto-Numbering/System Generated (Modified Date) field. It works with the assumption that the last change to the row is marking the Status as Complete, thus capturing the last action associated to the row. Unfortunately, if there are any other column changes to the full sheet or mass updates, that Modified Date/Time Stamp will change, thus altering the Turnaround Time calculation.

Anyone run into something similar? Any ideas to solve this? Can I get a snapshot of that Modified Date when the Status changes to Complete? Maybe I'm overlooking something very basic here.

Andrée Starå

Hi @Jake Gustafson

I hope you're well and safe!

This might help!

Please have a look at my post below with a method I developed.

More info: 

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

Would that work/help?

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Jake Gustafson

I hope you're well and safe!

This might help!

Please have a look at my post below with a method I developed.

More info: 

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

Would that work/help?

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jake Gustafson

Thanks Andrée. I think this will work pretty slick. I haven't gotten a chance to put it in place, but it'll kind of be one of the last pieces for me to implement, then this sheet and process should be ready to go live. I'll provide an update once I get it all created.

Jake Gustafson

Sorry @Andrée Starå, I got a little ahead of myself. How am I able to capture the Date/Time Stamp? I've got the extra column added using an Index/Match to reference the Unique Row ID, but it only displays the Date. Am I missing something?