track when duration exceeds set number of days and flag

[Balzyone]

I have one task that has a metric associated with it. I need to find a way
to have a visual indication for when that task exceeds 45 days. How can I
set this up?

 

[JulieS]

Hi Balzyone,

The quickest way may be to set a deadline on the task. Although you'll
need to figure out the deadline date, you will see a flag appear in the
indicator column if the task slips past that date.

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

 

[Mike Glen]

Hi Balzyone ,

Welcome to this Microsoft Project newsgroup

Try Project/Task Information/Advanced tab and set a Deadline Date 45 days
into the task. Search Help for Deadlines.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[Balzyone]

So there is not a way to set up an if then type of deal. kinda like- if dur
=>45d then display status red

 

[JulieS]

Hi Balzyone,

Yes, certainly. But unfortunately the formula would apply to all tasks,
not just the single task you seem to be interested in. In Project,
unlike Excel, you write a formula in a custom field and Project uses the
formula for all tasks not just for a single task.

You can cook up a work around with a combination of a flag field and a
custom field. If you insert one of the custom flag fields (Flag1 for
example) and set the field to "Yes" for the single task you are
interested in. Then insert a custom Number field (Number1 for example)
you could then create a custom formula that would test for Flag = "yes"
and Duration >= 45.

For example:

In the Number1 field I used the following formula:

IIf([Flag1]=-1 And [Duration]>=45*[Minutes Per Day],1,0)

For tasks with the Flag1 set to yes (-1 in example) and Duration is
greater than or equal to 45 days, the value in the Number1 field shows
1. If both conditions are not true, the value in the Number1 field
shows 0. You can then customize the Number1 field with a graphic
indicator (Flag or circle etc.) of your choice.

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

 

[Balzyone]

Hi Julie,
I tried to set it up like you said, but I could not figure out the Flag
settings. When I take the reference to the flag out, it seems to work at the
task level, but does not work for the summary level, which is what I need to
show. I did have the Flag set to yes on the summary level and that may be
why it did not seem to work with the exact formula you gave me. If it will
not show at the summary level, could I set it up to add the 4 tasks together
to get the cumulative duration to show over 45 days?

Hi Balzyone,

Yes, certainly. But unfortunately the formula would apply to all tasks,
not just the single task you seem to be interested in. In Project,
unlike Excel, you write a formula in a custom field and Project uses the
formula for all tasks not just for a single task.

You can cook up a work around with a combination of a flag field and a
custom field. If you insert one of the custom flag fields (Flag1 for
example) and set the field to "Yes" for the single task you are
interested in. Then insert a custom Number field (Number1 for example)
you could then create a custom formula that would test for Flag = "yes"
and Duration >= 45.

For example:

In the Number1 field I used the following formula:

IIf([Flag1]=-1 And [Duration]>=45*[Minutes Per Day],1,0)

For tasks with the Flag1 set to yes (-1 in example) and Duration is
greater than or equal to 45 days, the value in the Number1 field shows
1. If both conditions are not true, the value in the Number1 field
shows 0. You can then customize the Number1 field with a graphic
indicator (Flag or circle etc.) of your choice.

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

So there is not a way to set up an if then type of deal. kinda like-
if dur
=>45d then display status red

 

[JulieS]

Hi Balzyone,

My apologies. I assumed you only wanted the formula to calculate for
one specific tasks and not a summary task. If you wish to use the
formula for summary tasks, in the Customize Fields dialog box under
"Calculation for task and group summary rows:" select "Use Formula"

That should now show you the information for the summary task.

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

Hi Julie,
I tried to set it up like you said, but I could not figure out the
Flag
settings. When I take the reference to the flag out, it seems to work
at the
task level, but does not work for the summary level, which is what I
need to
show. I did have the Flag set to yes on the summary level and that
may be
why it did not seem to work with the exact formula you gave me. If it
will
not show at the summary level, could I set it up to add the 4 tasks
together
to get the cumulative duration to show over 45 days?

Hi Balzyone,

Yes, certainly. But unfortunately the formula would apply to all
tasks,
not just the single task you seem to be interested in. In Project,
unlike Excel, you write a formula in a custom field and Project uses
the
formula for all tasks not just for a single task.

You can cook up a work around with a combination of a flag field and
a
custom field. If you insert one of the custom flag fields (Flag1 for
example) and set the field to "Yes" for the single task you are
interested in. Then insert a custom Number field (Number1 for
example)
you could then create a custom formula that would test for Flag =
"yes"
and Duration >= 45.

For example:

In the Number1 field I used the following formula:

IIf([Flag1]=-1 And [Duration]>=45*[Minutes Per Day],1,0)

For tasks with the Flag1 set to yes (-1 in example) and Duration is
greater than or equal to 45 days, the value in the Number1 field
shows
1. If both conditions are not true, the value in the Number1 field
shows 0. You can then customize the Number1 field with a graphic
indicator (Flag or circle etc.) of your choice.

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

So there is not a way to set up an if then type of deal. kinda
like-
if dur
=>45d then display status red

:

Hi Balzyone ,

Welcome to this Microsoft Project newsgroup

Try Project/Task Information/Advanced tab and set a Deadline Date
45
days
into the task. Search Help for Deadlines.

FAQs, companion products and other useful Project information can
be
seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

Balzyone wrote:
I have one task that has a metric associated with it. I need to
find
a way to have a visual indication for when that task exceeds 45
days.
How can I set this up?