MS Project 2007 Custom Duration

By V0X ·
I have a project and I wish to increase the duration of a task automatically based on what I set as a customised field.

Example: -

I have a set of delay codes that each equate to a different set of values, 100 = 30, 200 = 15, based on this I have a customised field that does a lookup on this and presents the correct value to the project.

IIf([Text1]="100",30,0) & IIf([Text1]="200",15,0) & IIf([Text1]="300",100000,0)

I also have a duration field that takes the above value and adds it to the duration: -


Now this looks fine but project ignors that field and continues to use the Duration field so I now have two duration fields, the default one and the one I created, I want project to use the one I created or be able to update the default duration field.

Any ideas anyone?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums