J
John Cello
I currently have the following formula in our enterprise
global template to produce a red\yellow\green light to
track tasks. The problem I am running into involves a
master project. While the individual tasks show the
proper light, summary tasks do not. For example, a
summary task with 10 subtasks at 100% will still show red
or yellow, and the summary task will show a less than
100% complete. I'm assuming that this has something to do
with the start and finish dates. My guess is that if a
task is scheduled to finish sometime in the future, the
summary is going by that as opposed to the task actually
being completed ahead of schedule. Please review the
formula, and let me know if there is any way I can force
it to take into account the % complete.
Thanks in advance.
FORMULA:
IIf([% Complete]=100 Or ([Start]>Now()+1) Or [Duration]
=0,2,IIf([Finish]<Now() And [% Complete]<100,1,IIf([%
Complete]<(((1-([Finish]-Now())/([Finish]-[Start]))
*100)/1.3) And [% Complete]<100,3,2)))
global template to produce a red\yellow\green light to
track tasks. The problem I am running into involves a
master project. While the individual tasks show the
proper light, summary tasks do not. For example, a
summary task with 10 subtasks at 100% will still show red
or yellow, and the summary task will show a less than
100% complete. I'm assuming that this has something to do
with the start and finish dates. My guess is that if a
task is scheduled to finish sometime in the future, the
summary is going by that as opposed to the task actually
being completed ahead of schedule. Please review the
formula, and let me know if there is any way I can force
it to take into account the % complete.
Thanks in advance.
FORMULA:
IIf([% Complete]=100 Or ([Start]>Now()+1) Or [Duration]
=0,2,IIf([Finish]<Now() And [% Complete]<100,1,IIf([%
Complete]<(((1-([Finish]-Now())/([Finish]-[Start]))
*100)/1.3) And [% Complete]<100,3,2)))