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"
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives