How do I duplicate the behavior of % complete for another column.
I wish to duplicate the behavior the of system-provided % Complete field. I want to use it to total a value (say task budget) whereby values are only permitted to be entered at the task level, and the parent tasks automatically roll that up (in this case, sum the child task values to auto populate the parent value).
Answers
-
If you child row is a percent then just use the =SUM(CHILDREN())
-
Thank you Antonio. I've tested this. The additional behavior I'm looking for is that I want the system to prohibit anyone from over writing the calculated value in the rolled up parent task. Additionally, I want the behavior preserved (as in the system % complete) when someone adds or deletes lines, changes the indentation structure, etc. Sorry if this is a newbie question (I am one)...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!