Calculate Average days to close tickets

edited 01/11/23 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!