%complete tasklevel

T

Tim

Could someone tell me the formula for marking task red or
green if they are or not 100% completed. This is what I
have so far

IIf([% Complete]=100,0 IIf([%Complete]<(100),1)

thx
Tim
 
G

Gérard Ducouret

Hello Tim,

You could use the following formula in the Flag1 (for example) field :
IIf([% Complete]=100;-1;0)

Then, in the Format / Bar Styles... dialog box, create a new bar with the
color you want, which shows for :
Normal;Flag1

Hope this helps,

Gérard Ducouret
 
D

Dale Howard

Tim --

Given your situation, here's one formula that would work in a custom Text
field:

IIf([% Complete]=100,"Yes","No")

To set up the graphical indicators, set two tests for this field in the
Graphical Indicators dialog box:

Equals Yes Green stoplight
Equals No Red stoplight

In the Custom Fields dialog box, remember to set the option for Calculation
for task and group summary rows to Formula. By the way, the above is one of
several ways to write the formula, since this is more than one right answer,
depending on the user's situation. Hope this helps.
 
Top