Calculate Average of Task Progress, per Person

Options

Hello,

I am trying to create a dashboard showing the average task completion status' of a number of team members.

I feel this needs to be completed in Sheet Summary, but can't figure the right formula...

Essentially trying to get; AVG of Column [Status], IF Assigned to [Joe]

Any clues? thanks

PS. the dark rows are parent rows, calculating the overall average status of it's children


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!