T4/ MS Project: Creating advanced filters - Tutorial

Paid Tutorial: An access link will be sent to you after purchase.

In this MS Project tutorial you will learn how to create advanced filters.

• Filter milestones or KPIs that are important to your project

These filters would be useful for your complex projects.

👉 Discover the full training program

To start, let's add a "project name" column to easily identify which project each task belongs to. Right-click on the column header, then click "Insert Column" and type the column name. Then, assign a project name to each task. You can adjust the width of the column for better visibility.

Now, let's create an advanced filter to display only the project milestones. Go to the "View" tab, then click on "Filter" and select "New Filter". In the window that opens, name this filter. Then, add the criteria:

• Fields: Select the added column or type the column name.
• Conditions: Select "equal to".
• Value: Type "project".
• Select "And"
• Fields: Select column, task name or type "Name"
• Conditions: "contains"
• Value: Type "gate".

With these conditions, this filter will only show the tasks in the project that contain the word "gate". Click "Save" .

To apply this filter, go back to the "View" tab and select the filter you just created . To remove the filter, click the triangle next to "Tasks" in the column header and choose "Clear Filter".

Now let's add a "category" column to categorize our milestones. Right-click on the column header, then click "Insert Column" and select "Category". Assign categories to the milestones, for example, development, design, etc.

Finally, let's create a filter to display only milestones in the development category. Go to the "View" tab, then click on "Filter", choose "New filters" . In the window that opens, name this filter. Then, add the following criteria:

• Fields: "Category", conditions: "equal to", value: "development".
• Fields: "Name", conditions: "equal to", value: "gate".

Click "Save" and apply the filter . Feel free to experiment with other criteria to customize your filters to your needs. Thank you for following this tutorial.