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

[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

[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

[Anonymous]

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

[Author]

Posts