Calculate Average days to close tickets
I am trying to calculate the average days to close tickets by adding the days in days to close when the request status is "Completed", "No Longer Tracking", "Cancelled", "Duplicate" and divide by total closed ticket count. I get incorrect argument error when I count the days in the column based on condition.
=COUNTIFS({Demo-IntakeFormBusiness,Data,DataModels Daystoclos}, {Demo-IntakeFormBusiness,Data,DataModels RequestSta}, [Primary Column]8, {Demo-IntakeFormBusiness,Data,DataModels RequestSta}, [Primary Column]9)
Best Answer
-
Hi @Smartsheet_User,
You could create a Sheet Summary field called something like Avg Days to Close Tickets, and make this the formula for that field: =AVG([Days to close ticket]:[Days to close ticket])
All the best,
-Ray
Answers
-
Hi @Smartsheet_User,
You could create a Sheet Summary field called something like Avg Days to Close Tickets, and make this the formula for that field: =AVG([Days to close ticket]:[Days to close ticket])
All the best,
-Ray
-
Thank you Ray. Your suggestion worked :)
-
I have one more question on how to do the Weekly Count of tickets for the current quarter/last 12 weeks from today
-
I have added a column to calculate the week the ticket was completed using the formula
=IFERROR(WEEKNUMBER([Completion Date]@row), ""). How can I dynamically display the weekly count for past 12 weeks?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!