How to create custom filters in MS Project

MS Project has a large number of useful pre-set filters, which enable you to focus on particular aspects of your plan.
For example, you can apply a filter to view only unstarted tasks or overallocated resources. MS Project also allows you to create your own custom filters.

Steps to create your own MS Project filter

Go to the Project menu Project > Filtered for: > More filters

Adding more filters in MS Project

Click New and complete the fields in the Filter definition box. For the first condition ignore the And/Or column. Under Field Name select the field that you want to filter on, then select the test for example, contains or equals. Finally select the value. In the example below I have created a filter that will return any tasks with an Actual Finish date equal to the 12 November 2010.

Define the custom filter

Click the OK button to save the filter. Then click Apply to see the filter in action!

Apply a custom filter to your project

Creating custom filters in MS Project 2010

To create a custom filter in MS Project 2010 go to View then Filter: in the dropdown menu select New Filter. creating a custom filter in MS Project 2010
Another route is to click the triangle symbol in the right of the column heading for the column you want to filter. Select Filters then Custom....
second method for creating a custom filter in MS Project 2010

Video - create filter to find tasks with no predecessors

This video shows how to create a filter in MS Project which will find all tasks with No Predecessors, ignoring Summary Tasks.


To build the same filter in MS Project 2010 go to View > select the Filter drop down and select New Filter. Give the filter a Name and select Predecessors in the Field Name. Set Test to 'is less than' and Value(s) to '1'. Add another row with parameter of 'And'. Select Summary in the Field Name. Set Test to 'does not equal' and Value(s) to 'Yes'.
filter definition in ms project

Create a filter to find summary tasks with links

It is generally not recommended to link summary tasks in MS Project. PMI's scheduling best practice advises against linking summary tasks because the logic can be difficult to follow, and may create circular relationships in the schedule. For more information read Why you should avoid linking summary tasks.

To identify linked summary tasks create a custom filter that looks for summary tasks with predecessors. Select Summary in the Field Name. Set Test to 'equals' and Value(s) to 'Yes'. Add another row with the parameter of 'And'. Select Predecessors in the Field Name. Set Test to 'is greater than' and Value(s) to '1'.
filter summary tasks with links

Filters - applying a filter to your project plan

Read more guides on using Microsoft Project

 
Microsoft Project Templates