Re: RAG Status Indicators

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Misty,

You're welcome for the assistance and thanks for the feedback.

To create the RAG column:

Insert a spare text field in the table (left side of Gantt) through
Insert > Column.
Pick any of the Text1 through Text30 fields that are not in use.
Once you've inserted the field (column), right click on the column
heading and choose Customize Fields from the shortcut menu.
In the Customize Fields dialog box, click the Formula button and enter
the following formula:

[Status]

Do not enter an equal sign and make sure you include the square
brackets around the field name.
Click OK to close the formula box and click OK when the message about
replacing values appears. You should be back in the Customize fields
dialog box.

Click the Rename button to apply a name to the column as you need.

Under the Values to display section, click the Graphical Indicators.
In the graphical indicators set your tests and graphics as you wish:
First row:
Test: Equals
Value: 0
Graphic: Pick one for completed tasks
Second Row:
Test: Equals
Value: 1
Graphic: Pick one for on schedule tasks

Continue for Late tasks and future tasks in row 3 and row 4.

Click OK to close the Graphical Indicators and return to the Customize
Fields
Click OK to close the Customize fields dialog and show your RAG status
column.

Julie

"Misty" <Misty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:569727F4-E957-44C6-A725-91B7522B9554@xxxxxxxxxxxxxxxx
Hi Julie,

Many thanks for your prompt response and advice the only problem is
that i
don't know how to reference a field so would it would be very much
appreciated if you could offer any advice?

Thanks again



"JulieS" wrote:

Hi Misty,

You cannot change the indicators themselves but you can reference
the
Status field and create your own indicators in a spare text field.
The status field shows complete, on schedule, late, or future task.
Each status is actually a number that you can use to create the RAG
status.

Complete = 0
On Schedule = 1
Late = 2
Future Task = 3

I hope this helps. Let us know how you get along.

Julie
Project MVP

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


"Misty" <Misty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36E84ECA-3738-4C36-92DB-E85C5A5B6157@xxxxxxxxxxxxxxxx
Hi,

Does anyone know if you can change the status indicators to show
as
RAG
indicators?

Thanks in advance





.

Quantcast