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


  • hollyconradsmith
    hollyconradsmith ✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!