RE: Stop Light
- From: Jim Aksel <JimAksel@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 3 Dec 2008 16:02:05 -0800
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
"Sundos Masri" wrote:
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
- References:
- Stop Light
- From: Sundos Masri
- Stop Light
- Prev by Date: RE: Percent complete not rolling up to 100%
- Next by Date: RE: I want to assign hours to my tasks and track that way. How?
- Previous by thread: Stop Light
- Next by thread: Re: Stop Light
- Index(es):
Relevant Pages
|
