Friday, July 8, 2011

How to create MS Project task that auto extend if project is delayed

Someone asked me how I used to set up a task that is supposed to last the entire project (like Project Management task, or weekly meeting) and auto-update its end date if the project is delayed. Here is how to create such task:

This is my simple project file

I will create a new task #1 for project Management.
I copy the start date cell of the project summary task (Task #0), right click on the cell and select Copy Cell.


Then the idea is to paste this cell as a link on the Project Management task start date. Right click on the cell and click Paste Special.

On the paste special window, select Paste Link and Text Data, and then click on OK.


Note that the bottom right corner of the cell contains this grey triangle which means that the cell is linked to something.


Repeat this for the End Date.
If we now open the Task Inspector for this task, we see that there is a Finish No Earlier Than constraint type.
Let’s modify another task, for example let’s put 5 days for task 1’s duration.
 Note that the Project Management task has been extended until the new project end date.

6 commentaires:

Gary Larking said...

I learnt something from this - thank you. Ive been doing IT project management a long time and I didn't know this !

Jeremy Cottino said...

Thanks Gary for the note, appreciate it.

Anonymous said...

Hammocks work nicely UNTIL... you try to share the file with someone else. Then you discover that all the links are STORED as external file references to your local drive. How MS figured out this would be useful I don't know.

Jeremy Cottino said...

Thank you for the info, never noticed this before

Anonymous said...

Hi Jeremy, my name is Lindsey and write from Brazil.
I would like to ask a question about hammock.
I made a schedule using hammock, created activities as you teach, but when I update the schedule or change the time of the activities, the hammock activity takes too long to upgrade and sometimes hangs. Is there some setting I have to do to get faster?
Thank you for your help.

Jeremy Cottino said...

Hi Lindsey,
I have quickly checked and cannot reproduce your issue. Can you give me more info? Otherwise it seems to be related to your computer, try to open the task manager at the same time to check CPU and RAM usage...

Post a Comment