Sorry, no. Filter data (and custom field formulae) only access data for the
same task. To read data from other tasks requires a VBA Macro.
I use a macro that runs when any project is saved: it tests all predecessors
of any milestone under a Summary Task called Deliverables and sets them to
100% complete if all their predecessor tasks are complete. Put the following
code in a Module:
Sub MilestonesUpdateComplete(Tsks As Tasks)
Dim Tsk As Task
Dim TskPred As Task
Dim Done As Boolean
For Each Tsk In ActiveProject.Tasks("Deliverables").OutlineChildren
If Tsk.PredecessorTasks.Count > 0 And Tsk.Milestone Then
Done = True
For Each TskPred In Tsk.PredecessorTasks
If TskPred.PercentComplete < 100 Then
Done = False
Exit For
End If
Next TskPred
If Done Then
Tsk.PercentComplete = 100
End If
End If
Next Tsk
End Sub
And this code in the ThisProject file:
Private Sub Project_BeforeSave(ByVal pj As Project)
On Error Resume Next
If Not pj Is Nothing Then
If Not pj.Tasks("Deliverables") Is Nothing Then
MilestonesUpdateComplete
pj.Tasks("Deliverables").OutlineChildren
End If
End If
End Sub
For more VBA tips, come hear me talk at the project Conference in Phoenix Az
next Tuesday!
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com