S
Sonni
My Goal is to show green, yellow, red status for each tasks.(Green if task is
100 complete, yellow if task is in progress and did not exceed finish time,
red if task is exceeding finish time)
Therefore I added a customized field by inserting a colomn of text type.
Then I added the formula:
IIf([% Complete]='100',"green",IIf([% Complete]<'100' And
[Finish]<Date(),"red","yellow"))
And then I assigned graphical indicators, for gree a green button, yellow a
yellow button, red a red button)
It doesn't work correctly. It seems I am having problems with the Finish &
Date comparison.
When I change the % complete on a taks that has exceeded the finish time to
5% the status turns yellow instead of red, if I incease the % complete to 10%
the status turns back to red which is correct, increasing the % complete any
higher returns status the incorrect status yellow.
Any idea on how to compare the finish date with the actual date correctly?
Or
any idea on how to demonstrate green, yellow, red status for each task?
Thanks so much in advance!
100 complete, yellow if task is in progress and did not exceed finish time,
red if task is exceeding finish time)
Therefore I added a customized field by inserting a colomn of text type.
Then I added the formula:
IIf([% Complete]='100',"green",IIf([% Complete]<'100' And
[Finish]<Date(),"red","yellow"))
And then I assigned graphical indicators, for gree a green button, yellow a
yellow button, red a red button)
It doesn't work correctly. It seems I am having problems with the Finish &
Date comparison.
When I change the % complete on a taks that has exceeded the finish time to
5% the status turns yellow instead of red, if I incease the % complete to 10%
the status turns back to red which is correct, increasing the % complete any
higher returns status the incorrect status yellow.
Any idea on how to compare the finish date with the actual date correctly?
Or
any idea on how to demonstrate green, yellow, red status for each task?
Thanks so much in advance!