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

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #415266 Reply
    Tom Steger
    Guest

    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
    Guest

    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

    #417077 Reply
    HAVIP LAW
    Participant

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

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




44 − 39 =