Average Days from Days Opened formula

I have a formula in a column for the number of a days a ticket has been opened. 

=IF(Status@row <> "Completed", TODAY() - [Created Date]@row, "")

I want to add a metric in the sheet summary to tell me the average days of open tickets. I am using =ROUND(AVG([Days Opened]:[Days Opened], 1)), but this is accounting for closed tickets. How can I add a formula to only average the lines will values aka open tickets?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!