creating a graphical indicator

[chris]

I would like to create a graphic indicator for the "status" field that is different than the one provide by the "status indicator
field. Since I do not have access to the "status indicator" field to edit it can someone help me create the formula and the test condition for the graphical indicator.
I would expect a formula like: Switch([Status]="Complete",0,[Status]="Future Task",1,[Status]="On Schedule",2,[Status]="Late",3) Is this a valid formula
but then when I go into the graphical indicator the test only allows for 2 values yes-no. How do I test for multiple values
Thanks

 

[Dale Howard]

Chris --

To solve your problem, do the following:

1. Open a project, then click Tools - Customize - Fields.
2. Select any the Number field (since the Status field actually contains a
number and not text) and rename it to something like "Task Status".
3. In the Edit Formula dialog, enter the simple formula [Status] and
nothing more. Doing so will simply read the value in the Status field.
4. In the Calculation for task and group summary rows section, select the
"Use formula" option.
5. In the Values to display section, select the Graphical Indicators option
and set up the following tests:

Equals 0 Image for a task that is Complete
Equals 1 Image for a task that is On Schedule
Equals 2 Image for a task that is Late
Equals 3 Image for a task that is a Future Task

6. Click OK and then click OK again
7. Insert the new Task Status column in any task table.

Your new column with custom indicators should work as you wish. Let me know
if this helps.

I would like to create a graphic indicator for the "status" field that is

different than the one provide by the "status indicator"

field. Since I do not have access to the "status indicator" field to

edit it can someone help me create the formula and the test condition for
the graphical indicator.

I would expect a formula like:

Switch([Status]="Complete",0,[Status]="Future Task",1,[Status]="On
Schedule",2,[Status]="Late",3) Is this a valid formula ?

but then when I go into the graphical indicator the test only allows for 2

values yes-no. How do I test for multiple values ?

 

[Dale Howard]

Chris --

I thought you would want the status of each task to roll up to the summary
tasks. However, since you you do not, then complete the following:

1. Open the project then click Tools - Customize - Fields
2. Select the custom Number field you are using
3. Select the "None" option in the Calculation for task and group summary
rows section.
4. Click the Graphical Indicators button
5. In the Graphical Indicators dialog box, select the Summary Rows option
6. Deselect the "Summary rows inherit criteria from nonsummary rows"
7. Select the Project Summary option
8. Deselect the "Project Summary inherits criteria from summary rows"
9. Click OK and then click OK again

Hope this helps.

Thanks. I got this to work. Another question: is there a way to not have

the status rollup to the summary tasks ?