MS Project Formula

[Riele485]

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 it doesn't recognize the statuses. can anybody help me?

[#2]

@Riele485 

It fails because the Status field is not a text string, regardless of how it is displayed. Use these numerical values and your formula will work as desired.

John

[#3]

Thank you, John, for your contribution! But, I had already tried customizing numeric field, because I saw that the Status is as numeric. It still didn't work!
IIf([Status]="Late";1;IIf([Status]="Completed";2;IIf([Status]="Due";3;4)))

[#4]

I even tried:
IIf(Str([Status])="Delayed";"1";"2"), in text field

[#5 · Accepted solution]

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

[#6]

Thanks, John!

[#7]

Riele485,
You're welcome and thanks for the feedback. If I answered your questions, please consider marking my response as the answer.
John

[#8]

Change “;” with “,”