Calculate Average of Task Progress, per Person

GWOOD02

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

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

Beautiful! That worked perfectly. Thanks so much @Shubham

Shubham

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

Beautiful! That worked perfectly. Thanks so much @Shubham