How to hide tasks with incomplete predecessors?

[Rybtsov S.]

Hello,
Is there any way to hide or automaticly not publish (and publish when
predecessors will be completed) tasks with incomplete predecessors?
Or maybe it's possible to automatic set specific value to some field (for
filtering in outlook).
Thanks before.

 

[Jack Dahlgren MVP]

Yes there is but it will take a little bit of VBA automation.

I'd use one of the flag fields then iterate through all the tasks and flag
the ones which are ready to publish. Then filter to show just them.

Sub FlagTasksReadyToStart()
Dim t as Task
Dim p as Task
Dim ps As Tasks
Dim ts as Tasks

set ts = ActiveProject.Tasks
for each t in ts
if not t is nothing then
t.flag1 = True
'Find all predecessors
Set ps = t.PredecessorTasks
For Each p In ps
If p.percentcomplete < 100 then
t.flag1 = False
End If
Next p
end if
next t
End Sub

Then filter on Flag1

-Jack Dahlgren

-Jack Dahlgren

 

[Rybtsov S.]

In this way project manager will have to republish project each time, when
some predcessor finished?
Filtration is needed in PWA or outlook (but how to send user-created field
to the outlook?).