Home Forums Customization Have custom field summary roll DOWN to children tasks (Project Standard 2016)

This topic contains 1 reply, has 1 voice, and was last updated by  Tom Steger 3 months, 1 week ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #415266 Reply

    Tom Steger

    Let’s say I’m creating new features for a software app.

    Let’s say I have 100 new features to implement, and 40 release cycles to plan.
    They all have wildly variable work.
    They all also have ask dates from senior management.

    What I’m trying to do is for a release build of new features, use the maximum of the [Finish] date as the earliest possible date that all the new features in the release can launch.

    Then I want to calculate [DaysLate] vs the [AskDate].

    [Task Name (feature)] [Start][Finish] [AskDate] [EarliestPossibleLaunch] [DaysLate]
    Summary (N/A) 4/20
    Feature1 2/1/19 2/28 2/15 4/20 65
    Feature2 3/1/19 3/31 3/15 4/20 35
    Feature3 4/1/19 4/20 4/15 4/20 5

    Repeat for 40 releases…

    This way I can optimize which feature should go into which build, and minimize the pain (days late).

    How do I:
    Assign the value of a summary rollup date ([Finish]) and assign it to all of the children tasks as [EarliestPossibleLaunch] ?
    Can this be done without writing VBA?

    –Tom

    #415267 Reply

    Tom Steger

    Let’s say I’m creating new features for a software app.

    Let’s say I have 100 new features to implement, and 40 release cycles to plan.
    They all have wildly variable work.
    They all also have ask dates from senior management.

    What I’m trying to do is for a release build of new features, use the maximum of the [Finish] date as the earliest possible date that all the new features in the release can launch.

    Then I want to calculate [DaysLate] vs the [AskDate].

    [Task Name (feature)] [Start][Finish] [AskDate] [EarliestPossibleLaunch] [DaysLate]
    Summary (N/A) 4/20
    Feature1 2/1/19 2/28 2/15 4/20 65
    Feature2 3/1/19 3/31 3/15 4/20 35
    Feature3 4/1/19 4/20 4/15 4/20 5

    Repeat for 40 releases…

    This way I can optimize which feature should go into which build, and minimize the pain (days late).

    How do I:
    Assign the value of a summary rollup date ([Finish]) and assign it to all of the children tasks as [EarliestPossibleLaunch] ?
    Can this be done without writing VBA?

    –Tom

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: Have custom field summary roll DOWN to children tasks (Project Standard 2016)
Your information:




7 + 2 =