Calculate Average days to close tickets

Smartsheet_User

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)

Ray Lindstrom

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

Ray Lindstrom

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

Smartsheet_User

Thank you Ray. Your suggestion worked :)

Smartsheet_User

I have one more question on how to do the Weekly Count of tickets for the current quarter/last 12 weeks from today

Smartsheet_User

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?