How to calculate average response time in smartsheet?

Onkar
Onkar ✭
in Formulas and Functions
Screenshot 2021-12-10 at 1.26.46 PM.png

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

· Share on FacebookShare on Twitter

Answers

  • 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

    · Share on FacebookShare on Twitter
  • Onkar
    Onkar ✭

    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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!