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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives