Late status

[Negative hours]

Hi,
I'm trying to add graphical indicators for the below formula,
IIf([Status]="On

Schedule",0,IIf([Status]="Late",1,IIf([Status]="Complete",2,0)))

however the formula is always returning ZERO value.What's wrong with it?

Sam

 

[JulieS]

Hi Sam,

The Status field actual holds numbers but displays the text "On
Schedule", "Late" etc. I don't recall the specific numbers right
now, but if you add a number field (Number1) and create a formula of

[Status]

you'll be able to work out what number corresponds to which text.
Then just change your IIf function to refer to the numbers.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

Hi,
I'm trying to add graphical indicators for the below formula,
IIf([Status]="On

Schedule",0,IIf([Status]="Late",1,IIf([Status]="Complete",2,0)))

however the formula is always returning ZERO value.What's wrong
with it?

Sam