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?



  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.

  • JeremiahHorstick
    JeremiahHorstick ✭✭✭✭✭✭
    edited 01/14/21

    @Greg Peddell-Grant

    Considering all tasks equal:

    =SUMIF(CHILDREN(Include:Include), true, CHILDREN()) / COUNTIF(CHILDREN(Include:Include), true)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!