Conditional Task Length

[Erik L]

Is it possible to create tasks whose duration is
conditioned on another task. So if Task 1 is 10 days, I
want task 2 to be 20% of task 1? I know I can do this
through excel... but is there a way to do it in Project??

TIA!

 

[Mike Glen]

Hi Erik,

I think you'll need some vba code to do this. Try posting on the developer
newsgroup. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion
products and other useful Project information can be seen at this web
address: http://www.mvps.org/project/.

Mike Glen
Project MVP

 

[JackD]

It is possible, but it is a bit kludgy.
Do this.
Insert one of the number fields (number1, number2 ...)
Insert one of the duration fields
Let's imagine you are using Number1 and Duration1 for this example
right click on the header of the duration1 column
select customize.
click on the formula button
enter
[Duration]*[Number1]
click ok.

Now set the value in Number1 to be .2

Now copy the value in the duration1 cell
Go to the duration cell for the other task
From the edit menu select "Paste Special"
Make sure that the "Paste Link" radio button is selected.
Click OK.

Now when the first task changes in duration, the second task will change as
well.

-Jack

 

[Mike Glen]

Good catch, Jack, I hadn't thought of that


Mike Glen
Project MVP

It is possible, but it is a bit kludgy.
Do this.
Insert one of the number fields (number1, number2 ...)
Insert one of the duration fields
Let's imagine you are using Number1 and Duration1 for this example
right click on the header of the duration1 column
select customize.
click on the formula button
enter
[Duration]*[Number1]
click ok.

Now set the value in Number1 to be .2

Now copy the value in the duration1 cell
Go to the duration cell for the other task
From the edit menu select "Paste Special"
Make sure that the "Paste Link" radio button is selected.
Click OK.

Now when the first task changes in duration, the second task will
change as well.

-Jack

Is it possible to create tasks whose duration is
conditioned on another task. So if Task 1 is 10 days, I
want task 2 to be 20% of task 1? I know I can do this
through excel... but is there a way to do it in Project??

TIA!