Linking Schedules to a Master Schedule

Hi Team, My company has a master schedule that is at project phase level (Initiation, Planning, Execution, Monitor & Control and Project close. Is it possible to link in the project schedules (which have the same roll ups) to the master, so that % complete and dates that are rolled up in the project schedules update the master schedule?

All help appreciated

Dale

Answers

  • Gaby
    Gaby ✭✭

    Hi @dale3ME

    My undertanding is that you need to link the specific cells from the individual project schedules tot he master schedule and then use formulas in the masterschedule to add up the % complete and to roll up dates.

    e.g.

    Start Date: =MIN(CHILDREN())

    End Date: =MAX(CHILDREN())


    Hope this helps if you haven't found a solution yet.