Filter for activities without successors

[Jan De Messemaeker]

Hi Anton,

In a task view, insert the succesors column
Now activate the Auto filter (Project, Filtered For... there also is an Icon
on the toolbar)
You can filter for empty inthe sucessors column.

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[anton]

Hello,
How would you write such a filter.....someone set up a project with over
5000 activities....I need to check it Thanks.

 

[David Hunsberger]

Anton, Jan's solution below is excellent if you just want
to find the tasks and don't want to keep the filter
permanently. If you would like to create and save a
permanent filter to spot tasks with no successors, go to
More Filters and create a new filter with the logic:

Successors ---- equals ---- (blank)

where you type nothing at all in the last column.

When a client asks me to work with them on a project
schedule, I use a set of diagnostic filters including this
one (Tasks Lacking Successors) to find issues needing
attention in their schedule.

Regards, David Hunsberger
www.it7.com

 

[Jan De Messemaeker]

Hi Anton,

You can set in Number1 a formula Len([Successors]) and test for zero in any
filter.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[anton]

David,
Thanks....I tried null, "" but blank....
I'm trying to check a schedule (>5000 activities) submitted by a contractor.
What other diagnostic filters will be useful?
Thanks
Anton

 

[David Hunsberger]

Anton -- I create quite a few diagnostic filters,
including ones that look for links on summary tasks,
resources on summary tasks, tasks with certain date
constraints that I don't like (such as finish constraints
and MUST constraints), and tasks with both links AND
constraints so I can be sure the logic is good. You can
also look for tasks with leveling delays, since those
sometimes lead to timing that you didn't expect, and may
have been forgotten. Not everything caught in these
filters is an error, of course, but they give me a good
start in looking for problems.

Regards, David Hunsberger

 

[anton]

Thanks Jan and David...that was useful.

Anton -- I create quite a few diagnostic filters,
including ones that look for links on summary tasks,
resources on summary tasks, tasks with certain date
constraints that I don't like (such as finish constraints
and MUST constraints), and tasks with both links AND
constraints so I can be sure the logic is good. You can
also look for tasks with leveling delays, since those
sometimes lead to timing that you didn't expect, and may
have been forgotten. Not everything caught in these
filters is an error, of course, but they give me a good
start in looking for problems.

Regards, David Hunsberger