Customized field formula's

[Craig Anthony]

I'm wanting to find a way to set a formula under function to allow the
programme to show 3 different coloured indicators to represent RED for
critical (total slack 0), GREEN for non-critical (total slack between 1-5)
and YELLOW between 5 & greater within the programme so I can progressively
monitor the float within the detailed Ganett view?
Any help with the formula would be greatly appreciated

 

[Dave]

Insert a number column, Number1 say. Then add the formula

[Total Slack]/60/8 (assuming your working day has 8 hours).

The formula is entered by right clicking on the Number1 column heading
and then on Customise Fields. Clock on the formula button and click
through all the warnings. Division by 60 is necessary to convert from
minutes to hours and division by 8 converts to working days.

Then in the bottom of the Customise Fields dialogue box, click on
Graphical indicators and choose the tests, values and icons from the
various drop down boxes that are displayed.

I note that below you are using green for what you descibe as
non-critical and yellow for the most relaxed conditions so I wonder if
that is what you really meant but that is a minor detail.

 

[Jim Aksel]

Observation:
I understand the RED coding. However, might you have the Green and Yellow
reversed? Normally more slack is better... although a solid argument can be
made that slack > 5 days may be indicative of a missing predecessor link
somewhere in the schedule. It certainly looks like the other posters have
solved your problem.

In any event, sometimes there is no way to avoid slack >5 which would be
absolutely green. Just an observation for you to think about.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Chicago2Paris]

Is there a way to also do this yet not take into account tasks that have not
begun (start date is still in the future)? I'd like to suppress "red's" that
haven't started yet.

 

[Jim Aksel]

Hello Chicago2Paris - You can make a compound "IF" statement in the formulas
suggested to include testing on Future start dates. Note a future start
would be greater than the status date or Now() of you wish.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

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