Bar Style & Formula Question

[nmorph]

I am trying to format the bar styles in the detail Gantt view to show green
for on time, yellow for close to due date and red for past due. First, what
is the best way to show these in the bar styles dialog box? Second, do these
have to manually be updated?

Also, I have entered a column for schedule status that shows green, yellow
and red graphical indicators. I notice that they are often incorrect. The
formula I have entered is: IIf([% Complete]<100 And [Finish]<[Current
Date],"Red",IIf([% Complete]>50 And [% Complete]<100 And [Finish]>[Current
Date]-10,"Yellow","Green")). Do these have to be manually updated?

Thanks!

 

[Jan De Messemaeker]

Hi,

About the first question.
Set the relevant formula in Flag fields
Then in Bar Syles use the flag fields in the show for... column

And do read Faq 31 in our FAQs (URL in my signature below).
HTH

 

[nmorph]

I have problems writing the formulas in that I constantly get syntax errors.
I thnk I understand how to enter the bar styles - I just need the help on
entering the formula at this point. The formula on the FAQ link page helps
somewhat, but I'm not using the bar styles for resources just yet - only for
schedule status at this time.

Thank you for the link to the FAQ page. I know it will help me out!
Thanks so much!

Hi,

About the first question.
Set the relevant formula in Flag fields
Then in Bar Syles use the flag fields in the show for... column

And do read Faq 31 in our FAQs (URL in my signature below).
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm

I am trying to format the bar styles in the detail Gantt view to show green
for on time, yellow for close to due date and red for past due. First, what
is the best way to show these in the bar styles dialog box? Second, do these
have to manually be updated?

Also, I have entered a column for schedule status that shows green, yellow
and red graphical indicators. I notice that they are often incorrect. The
formula I have entered is: IIf([% Complete]<100 And [Finish]<[Current
Date],"Red",IIf([% Complete]>50 And [% Complete]<100 And [Finish]>[Current
Date]-10,"Yellow","Green")). Do these have to be manually updated?

Thanks!