Remaining Predecessors Custom Field - Need Help

[jdd23]

Hi,

I am working in a large Project document (1000+ tasks) with a lot o
dependencies. My goal is to create a formula in a custom field tha
shows only remaining/uncompleted predecessors, but I am having troubl
getting something that works. Would any of you be able to point me i
the right direction or provide me with a solution?

Thank you,
Jaso

--
jdd2
-----------------------------------------------------------------------
jdd23's Profile: http://forums.techarena.in/members/171363.ht
View this thread: http://forums.techarena.in/microsoft-project/1290250.ht

http://forums.techarena.i

[Dale Howard [MVP]]

Jason --

Right up front, I can tell you there is NO way to create a custom field and
formula to determine the uncompleted Predecessors. And I suspect that
writing a macro in VBA would be exceptionally challenging as well. If you
are open to a little manual analysis, I can give you a technique that should
speed up the analysis process. Here's how: create a custom View called
_Dependency Analysis (or something like that). To create this custom View,
complete the following steps:

1. Open the project in question.
2. Click View - More Views.
3. In the More Views dialog, click the New button.
4. In the New View dialog, select the "Combination view" option and click
the OK button.
5. In the View Definition dialog, enter the name of the new View in the
Name field.
6. Click the Top pick list and choose the Gantt Chart view.
7. Click the Bottom pick list and choose the Relationship Diagram view.
8. Select the "Show in menu" option and click the OK button.
9. Click the Apply button to apply the new View.
10. In the top pane (Gantt Chart), select a task whose Predecessors you
want to investigate.

You can do the preceding set of steps, in any version of Microsoft Project,
including the 2000, 2002, 2003, and 2007 versions. When you select a task
in the top pane, the bottom pane shows you all of the IMMEDIATE Predecessors
and Successors for the selected task. You can now scroll through the Gantt
Chart to examine the status of the immediate Predecessors, following the
information you see displayed in the lower pane. The limitation of this
process is that the bottom pane only shows immediate Predecessors; it does
not show all Predecessors.

Hope this helps, even if only a little. :)
--
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"

Hi,
I am working in a large Project document (1000+ tasks) with a lot of
dependencies. My goal is to create a formula in a custom field that
shows only remaining/uncompleted predecessors, but I am having trouble
getting something that works. Would any of you be able to point me in
the right direction or provide me with a solution?
Thank you,
Jason
--
jdd23
------------------------------------------------------------------------
jdd23's Profile: http://forums.techarena.in/members/171363.htm
View this thread: http://forums.techarena.in/microsoft-project/1290250.htm
http://forums.techarena.in

[sai]

Hi,
I am working in a large Project document (1000+ tasks) with a lot of
dependencies. My goal is to create a formula in a custom field that
shows only remaining/uncompleted predecessors, but I am having trouble
getting something that works. Would any of you be able to point me in
the right direction or provide me with a solution?
Thank you,
Jason
--
jdd23
------------------------------------------------------------------------
jdd23's Profile:http://forums.techarena.in/members/171363.htm
View this thread:http://forums.techarena.in/microsoft-project/1290250.htm
http://forums.techarena.in

Jason -

If I am right, you are looking for identifying tasks that don't
predecessor and/or successor.

I suggest you change your view to Gantt chart, and insert the column
"Successors"; "Predecessors" column is already visible, by default.
You can turn on the "Auto Filter" option on formatting toolbar, and
filter the tasks by "Predecessors" and "Successors" column with blank
value.

If you are still looking for a custom field, insert the field "Flag1"
in Gantt chart and follow the below steps:
1. Choose Tools | Customize fields, select "Custom Fields" tab.
2. Choose Task radio button and Type dropdown value as Flag.
3. Select "Formula" button under "Custom attributes" section
4. Enter the formula as [Predecessors]="" And [Successors]="" for this
field.
5. Save the settings
6. Turn on "Auto filter"in formatting toolbar, and filter the custom
flag field by false value.

Please let me know if this.

- Sai, PMP, PMI-SP, MCT, MCTS
http://saipower.wordpress.com

[jdd23]

Thank you for your help. I ended up going with Dale's recommendation.
had an inkling that what I wanted to do might not be possible, so thank
again for clearing that up before I spent to much time trying to figur
it out myself

--
jdd2
-----------------------------------------------------------------------
jdd23's Profile: http://forums.techarena.in/members/171363.ht
View this thread: http://forums.techarena.in/microsoft-project/1290250.ht

http://forums.techarena.i

[Dale Howard [MVP]]

jdd23 --

You are more than welcome for the help, my friend! :)
--
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"

Thank you for your help. I ended up going with Dale's recommendation. I
had an inkling that what I wanted to do might not be possible, so thanks
again for clearing that up before I spent to much time trying to figure
it out myself.
--
jdd23
------------------------------------------------------------------------
jdd23's Profile: http://forums.techarena.in/members/171363.htm
View this thread: http://forums.techarena.in/microsoft-project/1290250.htm
http://forums.techarena.in

[sai]

Thank you for your help. I ended up going with Dale's recommendation. I
had an inkling that what I wanted to do might not be possible, so thanks
again for clearing that up before I spent to much time trying to figure
it out myself.
--
jdd23
------------------------------------------------------------------------
jdd23's Profile:http://forums.techarena.in/members/171363.htm
View this thread:http://forums.techarena.in/microsoft-project/1290250.htm
http://forums.techarena.in

Thanks for confirming the solution that worked for you. I learnt new
solution today :-)

- Sai, PMP, PMI-SP, MCT, MCTS
http://saipower.wordpress.com