S
sarah
I am currently using this formula and linking this with the graphic indicator
to creative a trafic light system.
IIf([Baseline Start]>999999,"No Baseline",Switch(([Finish]-[Baseline
Finish])<=0,"On Schedule",([Finish]-[Baseline Finish])<=10,"1-10d
Late",([Finish]-[Baseline Finish])>10,">10d Late"))
Graphic indicator eg If "On Schedule" = green light
Is there anyway to link the trafic light so that when the task is on
schedule, the bar will be green and when it is "1-10d Late" the bar turns
yellow, etc??
Please advise
to creative a trafic light system.
IIf([Baseline Start]>999999,"No Baseline",Switch(([Finish]-[Baseline
Finish])<=0,"On Schedule",([Finish]-[Baseline Finish])<=10,"1-10d
Late",([Finish]-[Baseline Finish])>10,">10d Late"))
Graphic indicator eg If "On Schedule" = green light
Is there anyway to link the trafic light so that when the task is on
schedule, the bar will be green and when it is "1-10d Late" the bar turns
yellow, etc??
Please advise