Forum Discussion
Solved
MS Project Formula
Guys, I'm trying to apply a simple formula in the project, but I'm not having success: IIf([Status]="Late";"1";IIf([Status]="Completed";"2";IIf([Status]="Due";"3";"4"))) It always accuses 4, as if ...
- Riele485,
You missed the point of my answer, the custom field where you have you formula is not the problem, the problem is the test in your formula. This formula in a custom Number or Text field will work:
IIf([Status]=2;1;IIf([status]=0;2;IIf([Status]=3;4)))
By the way, there is no "Due" entry in the Status field, unless you created your own custom field called "Status". I assume by "Due" you mean "Future task".
John
Riele485,
You missed the point of my answer, the custom field where you have you formula is not the problem, the problem is the test in your formula. This formula in a custom Number or Text field will work:
IIf([Status]=2;1;IIf([status]=0;2;IIf([Status]=3;4)))
By the way, there is no "Due" entry in the Status field, unless you created your own custom field called "Status". I assume by "Due" you mean "Future task".
John
You missed the point of my answer, the custom field where you have you formula is not the problem, the problem is the test in your formula. This formula in a custom Number or Text field will work:
IIf([Status]=2;1;IIf([status]=0;2;IIf([Status]=3;4)))
By the way, there is no "Due" entry in the Status field, unless you created your own custom field called "Status". I assume by "Due" you mean "Future task".
John
Change “;” with “,”
