Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to make task which fills the gap between other two

7 replies [Last post]
Sun, 2008-01-13 18:42
Evgeny Z.
User offline. Last seen 38 weeks 5 days ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None
Hi,

I have the following question, on which I couldn’t find and answer in google.

How to make a task with flexible duration, which will fill the gap between other 2 tasks and will automatically adjust it’s length:
Example

Task1: Deliver building material (fix start task)
Task2: Guard delivered building material (fixed units)
Task3: Build building (fix start)

So, I want Task2 to fill the gap between task 1 and task 3. I want it to adjust it’s length depending on how late task 1 finishes. So, that it will always start when task 1 is finished, and will always finish, when task 3 starts. Is it possible with MS project?

thanks

Top

Replies

Fri, 2008-01-18 14:20
#1
David Sharp
User offline. Last seen 9 years 33 weeks ago. Offline
Joined: 15 Jan 2008
Posts: 4
Groups: Petro-Chem / Oil & Gas
Nice trick. Tried this "hammocking" using task with resources assigned/effort driven, seems to work well,could come in handy....good spot.
Top
Tue, 2008-01-15 12:36
#2
Nicolas Igersheim
User offline. Last seen 7 years 15 weeks ago. Offline
Joined: 25 Jun 2007
Posts: 62
Groups: Petro-Chem / Oil & Gas
Plus
a double click on the "linked" start and finish dates
will send the cursor automagically to the "source" dates.
Top
Mon, 2008-01-14 20:41
#3
Paul Harris
User offline. Last seen 1 year 3 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
This is a great little trick, but in my experience the “Task Type” must not be “Fixed Duration”.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
www.eh.com.au
Top
Mon, 2008-01-14 20:29
#4
Trevor Rabey
User offline. Last seen 1 year 21 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
You will see a small grey triangle in the corner of the cells which are "live" links.
See on the menu EDIT, LINKS.
It is a bit cryptic, not always easy to find which cell the target cell is linked to.
A note in the Notes field of the two Tasks helps a lot.
Top
Mon, 2008-01-14 06:22
#5
Evgeny Z.
User offline. Last seen 38 weeks 5 days ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None
Thanks! Great!
The more I learn MS Project, the more I get surprised!

But now I have another question, because these Excel-type links can be probably quite confusing:

Suppose I got an MS Project schedule from someone else and I have found linked fields there.

• How do I find out which cell it is actually linked to?

Regards.
Top
Sun, 2008-01-13 20:02
#6
Trevor Rabey
User offline. Last seen 1 year 21 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
This is called a "Hammock" Task.
Copy the Finish Date of Task1.
Select the Start Date cell of Task2.
Edit, Paste Special, Link.

Copy the Start Date of Task3.
Select the Finish Date cell of Task2.
Edit, Paste Special, Link.

Task2 will expand and contract to fill the gap.
Top