Creating Task Status Field Dependencies...?

[Andrew Lavinsky]

Was trying to link a Flag field to the Task Status field the other day w/
an "IIF" statement and couldn't. Was curious if anyone has some input on
the mechanics of using the Status field as a reference?

At first, I tried doing a text linkage: IIF([Status]="Complete",Yes,No)....that
didn't seem to work.

I had marginally better luck w/ a numerical linkage: IIF([Status]=1,Yes,No)...this
kind of worked for some options. I figured out that by using 1, 2, or 3
as a reference I could trigger different behavior in the flag field, but
this did not work when the Task Status was in fact "Complete" - or I couldn't
figure out the numerical code for that option.

I ended up tying the formula to the % Work Complete field, which served my
purposes, but was curious if anyone could tell me how in fact I should be
referencing the Status field.

Thks

-A

 

[Dale Howard [MVP]]

Andrew --

As you have surmised, the data in the Status field is numeric rather than
text. The field values are as follows:

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

You can now test the Status field based on the above values and conditions.
Hope this helps.