Status Indicator for Future Tasks

[Ris]

I have set up a custom field to display status indicators using Number1 with
formula %complete and the test for number 1 is
equals: value:0, Image: Red
is less than: value: 100, Image: Yellow
equals: valu: 100, Image: green

The problem I have is that the futur tasks are also being displayed with a
RED status indicator. What test can I add to this to allow future tasks to be
displayed in a different colour.

Or should I be using a different mothod.

Cheers
Ris

 

[JulieS]

Hi Ris,

Have you tried inserting the [Status] field and/or the [Status Indicator]
field in a view?

From Help on Status Field:
================================================
Description:

The Status field indicates the current status of a task, specifying whether
the task is Complete, On Schedule, Late, or a Future Task.

How Calculated:

If the task is 100 percent complete, then Microsoft Office Project 2003 sets
the Status field to Complete.

If the task start date is greater than the status date, then the Status
field contains Future Task.

If timephased cumulative percent complete is spread to at least the day
before the status date, then the Status field contains On Schedule.

If the timephased cumulative percent complete does not reach midnight on the
day before the status date, then the Status field contains Late.

==================================================
You may also insert the [Status Indicator] field to show a graphic. (See
help on the Status Indicator field.)

You could also use a graphic indicator to show graphics of your choice in
the [Number1] field. Set the formula for the [Number1] field to [Status].
The values for the [Status] field are:
Complete = 0
On Schedule = 1
Late = 2
Future Task = 3

Hope this helps. Let us know how you get along.

Julie

 

[Ris]

Hi Julie,

Yes this was one of the first thing I looked into, the [Status] field
displays the status in Text eg: Late, On Schedule, Future Task. And the
[Status Indicator] field displays the default MS Project indicators of a
tick or an excalmation mark and I'm not able to change these, or I'm not sure
how to change them to display the coulored circles.

THanks
Ris

Hi Ris,

Have you tried inserting the [Status] field and/or the [Status Indicator]
field in a view?

From Help on Status Field:
================================================
Description:

The Status field indicates the current status of a task, specifying whether
the task is Complete, On Schedule, Late, or a Future Task.

How Calculated:

If the task is 100 percent complete, then Microsoft Office Project 2003 sets
the Status field to Complete.

If the task start date is greater than the status date, then the Status
field contains Future Task.

If timephased cumulative percent complete is spread to at least the day
before the status date, then the Status field contains On Schedule.

If the timephased cumulative percent complete does not reach midnight on the
day before the status date, then the Status field contains Late.

==================================================
You may also insert the [Status Indicator] field to show a graphic. (See
help on the Status Indicator field.)

You could also use a graphic indicator to show graphics of your choice in
the [Number1] field. Set the formula for the [Number1] field to [Status].
The values for the [Status] field are:
Complete = 0
On Schedule = 1
Late = 2
Future Task = 3

Hope this helps. Let us know how you get along.

Julie

I have set up a custom field to display status indicators using Number1
with
formula %complete and the test for number 1 is
equals: value:0, Image: Red
is less than: value: 100, Image: Yellow
equals: valu: 100, Image: green

The problem I have is that the futur tasks are also being displayed with a
RED status indicator. What test can I add to this to allow future tasks to
be
displayed in a different colour.

Or should I be using a different mothod.

Cheers
Ris

 

[JulieS]

Hi Ris,

You can't change the existing indicators in the Status Indicator field, but
you can use the spare [Number1] field to show a custom indicator.

Customize the [Number1] field and in the formula dialog box enter [Status].

Set the calculation for group or summary row to use formula.

Then set the graphic indicators of:
Equals 0 and select the indicator of choice for Complete Tasks
Next Row in Graphical Indicators dialog box
Equals 1 and select the indicator of choice for On Schedule Task
Next Row in Graphical Indicators dialog box
Equals 2 and select the indicator of choice for Late Tasks
Next Row in Graphical Indicators dialog box
Equals 3 and select the indicator of choice for Future Tasks

Hope this helps. Let us know how you get along.

Julie

Hi Julie,

Yes this was one of the first thing I looked into, the [Status] field
displays the status in Text eg: Late, On Schedule, Future Task. And the
[Status Indicator] field displays the default MS Project indicators of a
tick or an excalmation mark and I'm not able to change these, or I'm not
sure
how to change them to display the coulored circles.

THanks
Ris

Hi Ris,

Have you tried inserting the [Status] field and/or the [Status Indicator]
field in a view?

From Help on Status Field:
================================================
Description:

The Status field indicates the current status of a task, specifying
whether
the task is Complete, On Schedule, Late, or a Future Task.

How Calculated:

If the task is 100 percent complete, then Microsoft Office Project 2003
sets
the Status field to Complete.

If the task start date is greater than the status date, then the Status
field contains Future Task.

If timephased cumulative percent complete is spread to at least the day
before the status date, then the Status field contains On Schedule.

If the timephased cumulative percent complete does not reach midnight on
the
day before the status date, then the Status field contains Late.

==================================================
You may also insert the [Status Indicator] field to show a graphic. (See
help on the Status Indicator field.)

You could also use a graphic indicator to show graphics of your choice in
the [Number1] field. Set the formula for the [Number1] field to
[Status].
The values for the [Status] field are:
Complete = 0
On Schedule = 1
Late = 2
Future Task = 3

Hope this helps. Let us know how you get along.

Julie

I have set up a custom field to display status indicators using Number1
with
formula %complete and the test for number 1 is
equals: value:0, Image: Red
is less than: value: 100, Image: Yellow
equals: valu: 100, Image: green

The problem I have is that the futur tasks are also being displayed
with a
RED status indicator. What test can I add to this to allow future tasks
to
be
displayed in a different colour.

Or should I be using a different mothod.

Cheers
Ris

 

[Ris]

Thank you JulieS it wokred exactly how I wanted it to.
you are an angel
Ris

Hi Ris,

You can't change the existing indicators in the Status Indicator field, but
you can use the spare [Number1] field to show a custom indicator.

Customize the [Number1] field and in the formula dialog box enter [Status].

Set the calculation for group or summary row to use formula.

Then set the graphic indicators of:
Equals 0 and select the indicator of choice for Complete Tasks
Next Row in Graphical Indicators dialog box
Equals 1 and select the indicator of choice for On Schedule Task
Next Row in Graphical Indicators dialog box
Equals 2 and select the indicator of choice for Late Tasks
Next Row in Graphical Indicators dialog box
Equals 3 and select the indicator of choice for Future Tasks

Hope this helps. Let us know how you get along.

Julie

Hi Julie,

Yes this was one of the first thing I looked into, the [Status] field
displays the status in Text eg: Late, On Schedule, Future Task. And the
[Status Indicator] field displays the default MS Project indicators of a
tick or an excalmation mark and I'm not able to change these, or I'm not
sure
how to change them to display the coulored circles.

THanks
Ris

Hi Ris,

Have you tried inserting the [Status] field and/or the [Status Indicator]
field in a view?

From Help on Status Field:
================================================
Description:

The Status field indicates the current status of a task, specifying
whether
the task is Complete, On Schedule, Late, or a Future Task.

How Calculated:

If the task is 100 percent complete, then Microsoft Office Project 2003
sets
the Status field to Complete.

If the task start date is greater than the status date, then the Status
field contains Future Task.

If timephased cumulative percent complete is spread to at least the day
before the status date, then the Status field contains On Schedule.

If the timephased cumulative percent complete does not reach midnight on
the
day before the status date, then the Status field contains Late.

==================================================
You may also insert the [Status Indicator] field to show a graphic. (See
help on the Status Indicator field.)

You could also use a graphic indicator to show graphics of your choice in
the [Number1] field. Set the formula for the [Number1] field to
[Status].
The values for the [Status] field are:
Complete = 0
On Schedule = 1
Late = 2
Future Task = 3

Hope this helps. Let us know how you get along.

Julie


I have set up a custom field to display status indicators using Number1
with
formula %complete and the test for number 1 is
equals: value:0, Image: Red
is less than: value: 100, Image: Yellow
equals: valu: 100, Image: green

The problem I have is that the futur tasks are also being displayed
with a
RED status indicator. What test can I add to this to allow future tasks
to
be
displayed in a different colour.

Or should I be using a different mothod.

Cheers
Ris

 

[JulieS]

Hi Ris,
You are most welcome and thanks for the feedback.
I think that's the first time I've ever been called an angel!

Julie

 

[Sajid]

Hi JulieS,
Thank for you suggestion, It helped my cause too.

But I have one more problem. I am not able to see these colored indicator on
my project file. I went ahead and added these new custom filed in the Project
Center view of the PWS(Project Web Access) I am not able to see the colors
appearing in View, I am only seeing the values. Am I missing some thing here,
please let me know

 

[JulieS]

Hi Sajid,

Glad to be of help but I don't use server extensively so I'm afraid I can't
help with the PWA question. You may have better luck posting the question
to the server newsgroup. Although several server "gurus" do check this
group as well, you may have faster response from the server newsgroup.
(Microsoft.public.project.server).

Hope this helps.

Julie

 

[Gary C.]

Julie,

I am seeking the same solution you provided to Ris, but I have Project 2000,
which apparently does not have a "Status" field, but only "% complete"
fields, which leaves me in the same position as Ris in the earlier message to
you. Is there a way to arrive at the same desired outcome in Project 2000?

Thanks,
Gary C.

Hi Ris,

You can't change the existing indicators in the Status Indicator field, but
you can use the spare [Number1] field to show a custom indicator.

Customize the [Number1] field and in the formula dialog box enter [Status].

Set the calculation for group or summary row to use formula.

Then set the graphic indicators of:
Equals 0 and select the indicator of choice for Complete Tasks
Next Row in Graphical Indicators dialog box
Equals 1 and select the indicator of choice for On Schedule Task
Next Row in Graphical Indicators dialog box
Equals 2 and select the indicator of choice for Late Tasks
Next Row in Graphical Indicators dialog box
Equals 3 and select the indicator of choice for Future Tasks

Hope this helps. Let us know how you get along.

Julie

Hi Julie,

Yes this was one of the first thing I looked into, the [Status] field
displays the status in Text eg: Late, On Schedule, Future Task. And the
[Status Indicator] field displays the default MS Project indicators of a
tick or an excalmation mark and I'm not able to change these, or I'm not
sure
how to change them to display the coulored circles.

THanks
Ris

Hi Ris,

Have you tried inserting the [Status] field and/or the [Status Indicator]
field in a view?

From Help on Status Field:
================================================
Description:

The Status field indicates the current status of a task, specifying
whether
the task is Complete, On Schedule, Late, or a Future Task.

How Calculated:

If the task is 100 percent complete, then Microsoft Office Project 2003
sets
the Status field to Complete.

If the task start date is greater than the status date, then the Status
field contains Future Task.

If timephased cumulative percent complete is spread to at least the day
before the status date, then the Status field contains On Schedule.

If the timephased cumulative percent complete does not reach midnight on
the
day before the status date, then the Status field contains Late.

==================================================
You may also insert the [Status Indicator] field to show a graphic. (See
help on the Status Indicator field.)

You could also use a graphic indicator to show graphics of your choice in
the [Number1] field. Set the formula for the [Number1] field to
[Status].
The values for the [Status] field are:
Complete = 0
On Schedule = 1
Late = 2
Future Task = 3

Hope this helps. Let us know how you get along.

Julie


I have set up a custom field to display status indicators using Number1
with
formula %complete and the test for number 1 is
equals: value:0, Image: Red
is less than: value: 100, Image: Yellow
equals: valu: 100, Image: green

The problem I have is that the futur tasks are also being displayed
with a
RED status indicator. What test can I add to this to allow future tasks
to
be
displayed in a different colour.

Or should I be using a different mothod.

Cheers
Ris

 

[JulieS]

Hi Gary C.,

Yes, but I wouldn't use the % complete field, or you'll run into the same
problem that Ris did - that future tasks that are not started (% complete is
0) will show as behind schedule.

If you want a stop light report based upon whether the task is late, you can
work with the [Finish Variance] field. The [Finish Variance] field shows the
difference between the [Baseline Finish] and [Finish]. If this is what you
are searching for try these steps:

Set the spare Number1 field formula to [Finish Variance]/480.

(Note: the divided by 480 is necessary to convert the value to days. If you
are using a definition of a day different that 8 hours adjust the number
accordingly.)

In the Graphic indicators set
Less than or equal to 0 - and select what ever indicator you want to use for
tasks either ahead of schedule or on schedule.
Less than or equal to and the number of days you wish to flag as "slightly
behind schedule"
Greater than and the number of days you wish to flag as seriously behind
schedule.

[Note these directions where done with Project 2002, but I think they apply
as well to Project 2000)

Hope this helps. Let us know how you get along.

Julie

Julie,

I am seeking the same solution you provided to Ris, but I have Project
2000,
which apparently does not have a "Status" field, but only "% complete"
fields, which leaves me in the same position as Ris in the earlier message
to
you. Is there a way to arrive at the same desired outcome in Project
2000?

Thanks,
Gary C.

Hi Ris,

You can't change the existing indicators in the Status Indicator field,
but
you can use the spare [Number1] field to show a custom indicator.

Customize the [Number1] field and in the formula dialog box enter
[Status].

Set the calculation for group or summary row to use formula.

Then set the graphic indicators of:
Equals 0 and select the indicator of choice for Complete Tasks
Next Row in Graphical Indicators dialog box
Equals 1 and select the indicator of choice for On Schedule Task
Next Row in Graphical Indicators dialog box
Equals 2 and select the indicator of choice for Late Tasks
Next Row in Graphical Indicators dialog box
Equals 3 and select the indicator of choice for Future Tasks

Hope this helps. Let us know how you get along.

Julie

Hi Julie,

Yes this was one of the first thing I looked into, the [Status] field
displays the status in Text eg: Late, On Schedule, Future Task. And the
[Status Indicator] field displays the default MS Project indicators of
a
tick or an excalmation mark and I'm not able to change these, or I'm
not
sure
how to change them to display the coulored circles.

THanks
Ris

:

Hi Ris,

Have you tried inserting the [Status] field and/or the [Status
Indicator]
field in a view?

From Help on Status Field:
================================================
Description:

The Status field indicates the current status of a task, specifying
whether
the task is Complete, On Schedule, Late, or a Future Task.

How Calculated:

If the task is 100 percent complete, then Microsoft Office Project
2003
sets
the Status field to Complete.

If the task start date is greater than the status date, then the
Status
field contains Future Task.

If timephased cumulative percent complete is spread to at least the
day
before the status date, then the Status field contains On Schedule.

If the timephased cumulative percent complete does not reach midnight
on
the
day before the status date, then the Status field contains Late.

==================================================
You may also insert the [Status Indicator] field to show a graphic.
(See
help on the Status Indicator field.)

You could also use a graphic indicator to show graphics of your choice
in
the [Number1] field. Set the formula for the [Number1] field to
[Status].
The values for the [Status] field are:
Complete = 0
On Schedule = 1
Late = 2
Future Task = 3

Hope this helps. Let us know how you get along.

Julie


I have set up a custom field to display status indicators using
Number1
with
formula %complete and the test for number 1 is
equals: value:0, Image: Red
is less than: value: 100, Image: Yellow
equals: valu: 100, Image: green

The problem I have is that the futur tasks are also being displayed
with a
RED status indicator. What test can I add to this to allow future
tasks
to
be
displayed in a different colour.

Or should I be using a different mothod.

Cheers
Ris