Averaging by Resolution Week

Options
fred sodergren
edited 06/11/20 in Formulas and Functions

If an issue has the label 'jira_escalated', I'd like to calculate how long it took to be resolved. (Solved in WorkDays column)

I have the columns week number (W#) and Resolution Week (RezW#).

How do I get an average time to resolution by week?

How do I calculate 4/8/12 week rolling averages?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!