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