How to calculate average response time in smartsheet?
I have these 2 columns and want to calculate the first time response, which is actually nothing but updated - requested, but its not giving me required output. Pls suggest
Answers
-
Hi @Onkar ,
What is the required output you are looking for?
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
As I said I just need the difference between 2 columns (first time response)
ex - If a request came in at 12/13 at 9 am CDT (A) and it was acknowledged at 12/13 at 9.15 am CDT (B) I want smartsheet to automatically calculate (B)-(A) and give me output as 15 min
Let me know if this helps or if you need any additional details for the same
Help Article Resources
Categories
Check out the Formula Handbook template!