Subscribe to our newsletter
Be the first to know about the latest solutions
Digital Factory
T4/ MS Project: Creating advanced filters - Tutorial
T4/ MS Project: Creating advanced filters - Tutorial
Couldn't load pickup availability
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.
Share
- Access your product in 30 seconds: steps 👇

FAQs
How will I receive links to the videos?
Links to the videos will be sent to the email address you used to place your order. Be sure to check your inbox and spam folder.
Will I have unlimited access to videos?
Yes, you will have unlimited access to videos for life. You can watch them as many times as necessary to fully assimilate the content.
Are the videos downloadable?
No, the videos are not downloadable. They are only accessible online via the links provided after ordering.
Can I share video links with others?
No, video links are strictly personal and should not be shared. They are intended solely for the use of the buyer.
Is there support available if I have questions about the content of the videos?
Yes, if you have any questions about the content of the videos, you can contact us at [hello@digitalfactory.store]. We would be delighted to help you.
Subscription offers
Subscription - Access to Excel, Power BI and Ms project tutorials and models
Corporate Pack
- No renewal constraints
- Full access to all tutorials:
- MS Project: Planning, Resources
- Power BI: Data Preparation, Dashboards
- Power Automate: Workflow Automation
- Full access to all models:
- Project management, Operational efficiency, Lean,...
- Premium Dashboards Included
- Unlimited downloads
- Personal space included
- 30 minute support included
Monthly Subscription
- Full access to all tutorials:
- MS Project: Planning, Resources
- Power BI: Data Preparation, Dashboards
- Power Automate: Workflow Automation
- Full access to all models:
- Project management, Operational efficiency, Lean,...
- Premium Dashboards Included
- Unlimited downloads
- Personal space included
- 30 minute support included
Annual Subscription
- All the advantages of the monthly
- Save 36% compared to monthly
- Priority consultation with an expert
- Updates and new models every week
Any questions?
