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.
Create additional dependency column to facilitate auto roll-up to parent
I created a new column "Effort". I want the "Effort" rolled up to the parent. That is not happening.
One of the FAQ states that column must be a dependency column. However, I can only see "Predecessors" and "Duration", when I go to <Project Settings/Dependencies Settings>
One way is to add a formula in the parent cell is, to sum-up everything under it. I hate to go this route as it is very manual, and I might end up messing it if I insert new rows.
Any ideas??
Peter.
Comments
-
Try using the CHILDREN() option of =SUM so that the formula will not need to change as you add rows.
On the parent row, use the formula =SUM(CHILDREN()).
-
Hi All—there isn't programmed functionality in Smartsheet for Effort but I've got your vote down for this feature on our enhancement request list for further consideration. At this time, the only way to calculate this would be through custom formulas that you place in the sheet.
Lee is correct in that the =SUM(CHILDREN()) formula is one way to go about this. A detailed list of our functions and their capabilities can be found in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas
-
Thanks Lee and Shaine. This will suffice for now.
However, it only works for pure numbers. I have the values as 2d, 10d , 16d to denote they are days and it won't work. Though the same behavior worked just fine with "Duration". Unless there is another trick I can use .
-
Please add my vote for this feature - looking to roll up 'benefit' columns
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives