Re: Rolled up milestones
- From: "JulieS" <JulieS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 11 May 2008 10:16:07 -0400
Hello Arintra,
Yes the formula below will set the flag to true if the task is both
set to rollup and the task is a milestone. If the task is not both a
rollup and milestone, the flag will remain "no".
IIf([Rollup]=True And [Milestone]=True,True,False)
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
"Arintra" <Arintra@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:57004773-6B48-4DD7-874F-59887C65ECCC@xxxxxxxxxxxxxxxx
Hi John,
I've a question about the formula your provided
->Flag1=IIf([Rollup],True,False).
If we just set this formula for the custom fields, it will apply to
all
rollup tasks. Is there any means to specify to only the milestone
rollup?
Regards,
Arintra
"John" wrote:
In article <A461D87C-602E-4C77-B066-5DB9BE0D47F9@xxxxxxxxxxxxx>,
Nenad80 <Nenad80@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
"John" wrote:
In articleJohn -
<1BB56BEC-7305-4F84-B99F-343EB8F419C8@xxxxxxxxxxxxx>,
Nenad80 <Nenad80@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I'm setting up a master project that has multiple
sub-projects inside of
it.
I'm rolling up major milestones to summary bars. I have also
added a
progress
bar style to the summary bar and the project summary bar.
Everything
looks
good in a rolled up form and it has allowed me to show the
project status
in
various levels of detail (depending on the audience).
One if the things that would really help me out is if I could
paint the
picture of how the different milestones are linked across
sub-projects
while
in this low detail view (single summary line per
sub-project). Is it
possible
to show links lines between milestones that are on summary
bars?
Nemad80,
Basically, no. But I've got a better idea. Instead of rolling
up the
major milestones to summary level, use a spare flag to identify
each one
and then use a filtered view of just those milestones. You
could also
show related summary rows if desired. If you have links between
the
milestones they will appear in the filtered view.
Hope this helps.
John
Project MVP
Thank you for the answer. Do you know if it is possible to add a
formula
that would automatically set a flag field to True if the
milestone is rolled
up?
Nenad80,
You're welcome. With regard to your new question, yes, use the
following
formula in a customized flag field (e.g. Flag1).
Flag1=IIf([Rollup],True,False)
Hope this helps.
John
Project MVP
.
- Prev by Date: Re: external task
- Next by Date: Re: Change Work field default to change hours, not duration?
- Previous by thread: Removing password-protected
- Next by thread: Re: Baseline Work Total in Resource Usage View
- Index(es):
Relevant Pages
|
