Task Text Formula

[TroyS]

Is it possible to have a task level custom Text field that shows a different
value at each separate task depending on what the formula resolves to? Seems
like the IIF statement is resolving to the same value on all tasks.

I'm using a Task level custom field = Enterprise Text4

For example (a simplified exmple) -->Based on what Today is (represented by
Now), i want to flag those tasks with a Start date less than Today :
IIf([Enterprise Date1]<=Now(),"Start Less than Today","Start Equal To
Greater Than Today")

Though i have the formula to be calculated for summary tasks, all tasks show
the same text value, though Start for each tasks is different from Now().

Some task's Start is earlier than Now() and some task's Start is later than
Now(), yet when i use F9, the values on each task resolve to the same value.

Any suggestions (on what i'm doing incorrectly) are appreciated. thx.

 

[TroyS]

Ignore this post. I was able to figure out