Creating % complete for each parent row?
Comments
-
Hi Monica,
If you go into your Project Settings and select the column as a % Complete column, it will be automatically rolled up.
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks for your reply! Unfortunately that doesn't seem to be an options as we aren't using dates?
-
Thanks for your reply! Unfortunately, this doesn't seem to be an option since we aren't using dates? I've attached a screenshot.
-
There is a manual way, as well. I'll get back to this post a little later.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Would this formula help?
=AVG(CHILDREN())
NOTE: be sure to change the column type to %
-
Happy to help!
I saw that it's answered already!
Let me know if I can help with anything else!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hmm, I feel like I'm missing something very obvious. I tried using the formula - =AVG(CHILDREN()) - but it results in something that I wasn't expecting. I would expect to see 75% here, but instead see 38%. Attaching screenshots. Any ideas? Thanks again!
-
Never mind! Figured it out! Instead of "=AVG(CHILDREN())" I needed "=Sum(CHILDREN())
:-) Thanks!
-
Excellent!
So you didn't want % Complete up to 100% but sum the % in total.
Glad you got it working!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives