Traffic Light on Project

C

CarharttRandy

Seeking a little traffic light help here. By using the following formula, I
can place a RED indicator light on those tasks that are late and a Green
indicator light on everything else.

IIf([Finish]<now() And [Remaining Work]<>0,"LATE","OK")

What I really want to do, is:
(1) Place RED indicator for late tasks,
(2) a GREEN indicator for on-time tasks, and
(3) a WHITE indicator for tasks that haven't been scheduled to start yet.

Anyone know how to do this? Thanks much!!!
 
B

bill_murphy

Try this I have not tested it because I am just working from home
I have use a number of repeating Immediate Ifs an find them more
sucessful than the Switch.
IIF([Finish]<Now() and [Remaining
Work]<>0,"LATE",IIF([Start]>Now(),"TODO","OK"))
 
Top