Linking Cells

[cathagge]

I have a Master Project with multiple embedded subprojects. I have a custom
field on the master project that I need to link to a custom field that is
contains individual information in each subproject. The goal is to be able to
view a summary task status for each Subproject on the Master Project.
Subprojects are embedded and hyperlinked. Can this be done?

 

[DonL]

catthagge,

Would you mind providing some additional information re: the custom field
(e.g., flag, numeric, text, etc...), and the logic of how the information is
to be rolled up to the summary level?

 

[cathagge]

There's actually a few custom fields. This is for a construction
company, each subproject is a house they're building. The first custom field
I would like to do (and I know this is difficult) is a summary field that
will tell the last task marked complete for each subproject. The owner wants
to know at a glance where each house is at.
The second, and this is a bit different, is to set up an indicator
field to alert when a subproject task slips it's deadline.
Finally, I set up a custom Text field in the template I'm using
for my subprojects. This is a "task belongs to" field and indicates who's
responsible for overseeing a task, since this company's resources are
subcontractors, not employees. The first name in the Belongs To
collumn on each Subproject is the overall Superintendant for building that
house. I have the same custom field setup on the Master Project. I want the
Master Project custom field to show the Superintendant for each house.
I'm very new to Project, but am in charge of setting this up. I
have no way of knowing if what the owner is asking for is feasible or not.
Any assistance you can provide is greatly appreciated!! Thank you.

 

[DonL]

cathagge,

Out of the 3 fields you wish, the indicator that a task is past its deadline
is the only "feature" that exists in Project without VBA or other
customization. If you display (i.e., add) the Indicators field in a table,
and set the Deadline field on the Advanced tab in the Task Information window
(double-click on a task line), an indicator will show in the Indicator field
when the Finish date exceeds the Deadline date set. This may still require
some VBA if you want summary information (e.g., statistics, etc...), though.

The other custom fields will probably require VBA coding, but should be
possible - by someone more knowledgeable than myself. You should repost your
(detailed) requirements in the MSP "Developer" forum for better feedback.

I hope this helps....

 

[JackD]

1) The custom field for last task has to be done via VBA

Something like this which puts the text you want in the text1 field.

Sub cat()
Dim sumT As Task
Dim T As Task
Dim lastOne As String
Dim latestDate As Date
For Each sumT In ActiveProject.Tasks
If Not sumT Is Nothing Then
If sumT.Summary Then
latestDate = 0
lastOne = "No completed subtasks"
For Each T In sumT.OutlineChildren
If Not T.Summary Then
If T.PercentComplete = 100 Then
If T.Finish > latestDate Then
latestDate = T.Finish
lastOne = T.Name
End If
End If
End If
Next T
sumT.Text1 = lastOne
End If
End If
Next sumT
End Sub

Instructions on how to install this macro can be found at my site
http://masamiki.com/project/macros.htm

2) Should be easy using a spare text field and a formula:
[finish]-[deadline]
then set a graphical indicator for that field

3)Try going to the tools menu / options/ view tab and check the box that
says display project summary task. Put the sup. name in the correct field.
It should roll up to the master file.

 

[cathagge]

Thank you! This helps me out tremendously.