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: –
[Duration]+[Number1]
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?