walnutthewise
Computer
- Dec 22, 2008
- 1
I am looking for some help on a switch statement formula I am using in a custom text field. This is a modified version of the schedule status indicator field you can find on several blogs. My goal is to get a field that shows a graphic indicator based on the amount of variance from the baseline.
The formula below works, but only green and red show up in the last three statements of the switch. The yellow parameters do not work for some reason so any task slippage results in "red". I think I may have something in the wrong order. Any help will be much appreciated.
Switch([% Complete]=100,"Complete",
(([% Complete]<100) And ([Finish]<Date())),"Overdue",
(([Baseline Start]=ProjDateValue("NA")) Or ([Baseline
Finish]=ProjDateValue("NA"))),"No BL",
[Finish Variance]<=0,"Green",
(([Finish Variance]>=1,"Yellow") or ([Finish Variance]<=21,"Yellow")),
[Finish Variance]>=22,"Red")
The formula below works, but only green and red show up in the last three statements of the switch. The yellow parameters do not work for some reason so any task slippage results in "red". I think I may have something in the wrong order. Any help will be much appreciated.
Switch([% Complete]=100,"Complete",
(([% Complete]<100) And ([Finish]<Date())),"Overdue",
(([Baseline Start]=ProjDateValue("NA")) Or ([Baseline
Finish]=ProjDateValue("NA"))),"No BL",
[Finish Variance]<=0,"Green",
(([Finish Variance]>=1,"Yellow") or ([Finish Variance]<=21,"Yellow")),
[Finish Variance]>=22,"Red")