Stop Light

[Sundos Masri]

hello.
I have inserted the follwoing formula on a project plan: IIf([%
Complete]>=80,"Green",IIf([% Complete]>=50,"Yellow","Red")). if %
complete>= 80 then make it green, if % complete>= 50 then make it yellow and
if not then make it Red.

the above formula is not looking at the start date first?
I would prefer to look at the date first, if the start date is less than the
current date, then look at the percent complete to determine the color. If
the task isn’t scheduled to start yet, then it should be blank (no color).
So how can I correct the formula or what step should I take to do exactly
that. Please advise.

Thanks
SM

 

[Jim Aksel]

drop me a note at jeaksel (at) yahoo (dot) com. I have a white paper that
will give you most of the answers you need along with several formulas.
Pleasemention your question in the email.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[ProjmanZA]

hello.
I have  inserted the follwoing formula on a project plan: IIf([%
Complete]>=80,"Green",IIf([% Complete]>=50,"Yellow","Red")).  if  %
complete>= 80 then make it green, if  % complete>= 50 then make it yellow and
if not then make it Red.  

the  above formula is not looking at the start date first?
I would prefer to look at the date first, if the start date is less than the
current date, then look at the percent complete to determine the color.  If
the task isn’t scheduled to start yet, then it should be blank (no color).  
So how can I correct the formula or what step should I take to do exactly
that.  Please advise.  

Thanks
SM

Hi there ,

Seems like your formula is n bit wrongish Try this:

IIf([% Complete]>=50,"Yellow",IIf([% Complete]>=80,"Green","Red")

Andre

 

[Jim Aksel]

It is actually much more complicated than that, if a task started yesterday
and is 100 days long, it will only be 1% complete today. That task is on
schedule and should show green. The formula provided would indicate red.

Similarly, a task that is 100 days long should be 95% complete on day 95.
If the user claimed 80% they are behind schedule and should show yellow or
red, not the green indicated by the formula.

So the formula needs to be sensitive to the start date and an expected rate
of completion.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

hello.
I have inserted the follwoing formula on a project plan: IIf([%
Complete]>=80,"Green",IIf([% Complete]>=50,"Yellow","Red")). if %
complete>= 80 then make it green, if % complete>= 50 then make it yellow and
if not then make it Red.

the above formula is not looking at the start date first?
I would prefer to look at the date first, if the start date is less than the
current date, then look at the percent complete to determine the color. If
the task isn’t scheduled to start yet, then it should be blank (no color).
So how can I correct the formula or what step should I take to do exactly
that. Please advise.

Thanks
SM

Hi there ,

Seems like your formula is n bit wrongish Try this:

IIf([% Complete]>=50,"Yellow",IIf([% Complete]>=80,"Green","Red")

Andre