Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
do you list each user under a parent row to seperate them. This would allow you to do what you are working on.
Here is a screen shot of part of the project plan.
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!
Thanks Travis. I swear I will get these formulas down one day.
