Hi all,
I am currently working in MS Project 2003 and need some help with setting up a formula in a custom duration column.
I have a text collumn (Text12) which has 4 possible values from a value list:
Major Works
Standard Works
Minor Works
Immediate Works
I now want a duration column that reflects the following;
Expression Duration Value
Iif((Text 12) = "Major Works" -65 days
Iif((Text 12) = "Standard Works" -10 days
Iif((Text 12) = "Minor Works" -3 days
Iif((Text 12) = "Immediate Works" +2 hours
Iif((Text 12) = "" ""
I think i am nearly there but it isn't working, this is what i have so far;
Iif((Text 12)="Major Works",-65 days, Iif((Text 12)="Standard Works",-10 days,Iif((Text 12)="Minor Works",-3 days,Iif((Text 12)="Immediate Works",+2 hours,""))))
I believe i need it as a duration as i want to then use it in another custom date collumn & with bar formatting, but any other suggestions are welcome.