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.
How to calculate schedule % updates in Smartsheet
Hi,
I use smart sheet for tracking my project progress. i would want to add one more column similar to % complete to calcuate my schedule percentage based on the number of days complete till date divided by duration.
i added a column with percentage updates as per schedule however, these percentages do not roll up to the parent like it does in the % complete.
Any help is welcome.
Regards,
Deepa
Comments
-
Deepa,
The rollup you describe is set in the gantt settings. Gantt view only supports 1 rollup as it uses start, finish, predecessors, and duration columns to calculate this information. With more specifics I may be able to help you create a formula for what you are attempting to do! To start entering a formula in a cell, start with an equals sign. More information on formulas can be found here: https://help.smartsheet.com/articles/775363-using-formulas
-
Benjamin,
Thank you for sharing this, i treid using the formula AVG(Children()), i did make a little progress. However not able to roll all the sub parents to the Final / top most overall percentage, can you help here?
-
Deepa,
You may need to individually select the cells you want to average. I am not sure how your sheet is set up but a simple average of all individual values may work for you?
Something like this
=AVG([Column2]2, [Column2]4, [Column2]7, [Column2]11)
-
Benjamin,
I did that, but it does not roll up like the % complete column does it.
Any thoughts? Is there a way where i can share my sheet with you?
-
It is hard to help without seeing your data. If you think sharing the sheet would help, you can share to [REMOVED] and I can take a look and help you proceed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives