Calculate Average of Task Progress, per Person

GWOOD02 · 09/01/23

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

Shubham · 09/01/23

Hi GWOOD02,

Please try the follwing formula-

=(AVERAGEIF([Assigned To]:[Assigned To], "Joe", Status:Status)) * 100

You just need to change the name in the formula, and it will return the average of that person.

Thank you,

Shubham Umale

Associate - Smartsheet, Ignatiuz Software

GWOOD02 · 09/01/23

Beautiful! That worked perfectly. Thanks so much @Shubham

Shubham · 09/01/23