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
- 65.3K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!