|
|
#2
02-05-2022, 03:13 AM
|
||||
|
||||
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 |
Windows 10 
Office 2019
Threaded Mode