Indicator colors

[Max]

I want to know whats wrong with this formula

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

I have created a new field(update status=number field) to display the
icons(0=Greenindicator, 1=yellowindicator,2=greensmileindicator)

But the formula always shows me greenindicator

 

[Max]

Thanks a lot for letting me know of the field being a number field
now it works fine.

The Status Date has a numeric value even though it displays text.

0 = Complete
1 = On Schedule
2 = Late
3 = Future Task

Just change the formula in the spare Number field to:
[Status]
that's all, and then use the graphic indicators.
You should account for the 4 possibilities.
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

I want to know whats wrong with this formula

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

I have created a new field(update status=number field) to display the
icons(0=Greenindicator, 1=yellowindicator,2=greensmileindicator)

But the formula always shows me greenindicator