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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!