Calculate Average of Task Progress, per Person



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!