Problems Using Graphical Indictators

[clibby11]

I am trying to set up a column to show graphical
indicators of Red-Yellow-Green for projects but not sure
how to do that or have it trigger an indicator based on a
condition. Example: If a project is 40% complete or less I
would like it to say is red. Or another example, if the
actual date is later than the planned end date of the task
by 2 days show Red as the graphical indicator.

Help!!

Thanks

 

[Patty]

I have accomplished this by creating a custom text field with the formula: IIf([% Complete]=100,"G",IIf(([Finish Variance]/60)/8<=7,"G",IIf(([Finish Variance]/60)/8>14,"R","Y"))

The formula sets the values as follows
G = finish variance <= 7 days or task is complet
R = finish variance > 14 day
Y = finish variance > 7 days but less than 15 days

I then select a Red/Green/Yellow icon in the Use Graphical Indicators area

----- (e-mail address removed) wrote: ----

I am trying to set up a column to show graphical
indicators of Red-Yellow-Green for projects but not sure
how to do that or have it trigger an indicator based on a
condition. Example: If a project is 40% complete or less I
would like it to say is red. Or another example, if the
actual date is later than the planned end date of the task
by 2 days show Red as the graphical indicator

Help!

Thank