Project Plan - Excluding rows from the overall completion percentage calculations
I am creating a project plan that will be used for Lifecycle maintenance programmes.
Each project plan will consist of up to 8 different work packages which will have their own task lines in. (See attached pic)
This basic format will be the standard for all Lifecycle programmes. One of these will be for one of the buildings we look after.
Not all programmes will have approved work to do in all 8 work packages so I have created the tick flag to show if they are part of the programme or not.
This will help with reporting and dashboard creation but what I want to do is have the parent % calculations to exclude any rows that are not part of the programme?
As you can see in the pic it shows unticked rows feeding into the parent % total? Even if I delete the row % or N/A it still includes it?
Is there anyway to automatically exclude if not selected?
Thanks.
Answers
-
Are you using dependencies? If so, it is not possible to exclude certain rows. You would need to turn off the dependencies and then use formulas to replicate these functions.
I have not yet had to replicate Predecessor and Duration columns, so I would have to do some testing on those if they are needed, but I have set up formulas to replicate the dependencies for the start and end dates as well as the % Complete and status if you would be interested in some help getting those set up.
-
Considering all tasks equal:
=SUMIF(CHILDREN(Include:Include), true, CHILDREN()) / COUNTIF(CHILDREN(Include:Include), true)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 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
Check out the Formula Handbook template!