#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Average % complete if task is assigned to "xxx"

Options
edited 12/09/19

What I am trying to do is figure out an assigned user's bandwidth. I am doing this by having them assign a % Complete to a task and then averaging the children =AVG(CHILDREN()). What I want to be able to do is average the children but only for specific assigned users. So average the children (% Complete) for tasks assigned to user XXX.

## Comments

• ✭✭✭✭✭
Options

do you list each user under a parent row to seperate them. This would allow you to do what you are working on.

• Options

Here is a screen shot of part of the project plan.

• Employee
Options

Hi Jeff, I built a formula to get the average % Complete for a specified user.

=(SUMIF(CHILDREN([Assigned To]3), "DCI", CHILDREN([%  Complete]3))) / (COUNTIF(CHILDREN([Assigned To]3), "DCI"))

This will first sum the % Complete values if the Assigned to is DCI then divides it by the number of tasks DCI is assigned it.

Enjoy!

• Options

Thanks Travis. I swear I will get these formulas down one day.

This discussion has been closed.