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?

Status field in formula is a number. So your formula always returns 4 because all the other conditions are wrong.

See screenshots below for simpler solution.





But if you want to use your own numbers for Status (which I won't recommend), then use the formula below

IIf([Status]=2,1,IIf([Status]=0,2,IIf([Status]=1,3,4)))

Planners' Place