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?