#1
|
|||
|
|||
Fórmula MS Project
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
|
||||
|
||||
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 |
Tags |
formula, status |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Graphical indicator formula for MS Project | Quinn87 | Project | 2 | 03-28-2021 11:38 PM |
MS Project - RAG status formula | imzkhan4 | Project | 0 | 11-13-2018 12:25 PM |
Formula for cum work in Project 2003 | pwhill | Project | 5 | 11-09-2014 03:22 PM |
Formula To Calculate Countdown Days To Project Completion | Catherine | Project | 1 | 02-19-2014 11:15 AM |
Implementing excel formula in project | nawab35 | Project | 6 | 08-04-2011 05:45 AM |