How to Combine Date and Custom Filters in Microsoft Project
Question details
The user wants to generate a management report by filtering tasks using a combination of a date-range filter and a custom flag or text field.
- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Creating a focused management report that only displays selected tasks and subtasks falling within a specific date range and meeting custom field criteria.
- Observed behavior
- Needing a reliable method to simultaneously apply date constraints and custom field (Flag/Text) conditions to a project view without overcomplicating the filter logic.
Before creating your combined filters, ensure that your custom Flag or Text fields are correctly defined and populated for all relevant tasks in your project schedule.
Use a Custom Flag Field as an AND Condition
Combine a single custom Flag field with your date-range filter using an AND condition to easily identify and isolate required tasks.
This method simplifies your filtering process. Instead of managing complex text conditions, you use a simple Yes/No flag to mark the tasks you want to include in your management report, and then intersect that with your date range.
Navigate to the 'Project' tab, click on 'Custom Fields', select a 'Flag' field (such as Flag1), and rename it to represent your reporting need (e.g., 'Report Inclusion').
Go through your project task list and set your newly created Flag field to 'Yes' for every task and subtask that needs to appear in the report.
Go to the 'View' tab, click the 'Filter' dropdown, select 'More Filters', highlight your existing Date Range filter, and click 'Edit'.
In the filter definition box, add a new row. Set the 'And/Or' column to 'And', the 'Field Name' to your custom Flag field, 'Test' to 'equals', and 'Value' to 'Yes'.
Click 'Save' and then apply the filter. Your view will now only display tasks that fall within the specified dates and have the flag set to Yes.
Create Separate Date-Range Filters for Flag and Text Fields
Use this approach if your reporting requires you to keep the Flag and Text field criteria completely independent from each other.
Manage Project Data Effortlessly with WPS Office
If you are managing project task lists, timelines, or reports and don't need the heavy complexity of Microsoft Project, WPS Spreadsheet is a highly capable and cost-effective alternative. It allows you to track tasks, apply complex multi-column filters, and manage dates with ease.
- 1. Import Your Task List: Open WPS Spreadsheet and load your project task list or export your existing Microsoft Project data to an Excel format and open it in WPS.
- 2. Enable Data Filtering: Highlight your header row, go to the 'Data' tab, and click the 'Filter' icon to add drop-down arrows to your columns.
- 3. Apply Multiple Conditions: Click the filter arrow on your Date column to set 'Date Filters' (e.g., Between), and use the custom text or flag column filters to refine your management report.
Frequently Asked Questions
Can I use AutoFilters for date ranges in Microsoft Project?
Yes, you can use AutoFilters by clicking the dropdown arrow on any date column heading, selecting 'Filters', and then 'Custom' to specify a specific date range.
Why is my combined filter hiding summary tasks in Project?
If your summary tasks do not meet the criteria of your custom Flag or Text field (for example, if the flag is left as 'No'), they will be hidden. To keep them visible regardless of the criteria, check the 'Show related summary rows' box in the filter definition dialog.
How do I share my custom project filter with others on my team?
You can share custom filters using the Organizer tool. Go to 'File' > 'Info' > 'Organizer', select the 'Filters' tab, and copy your custom filter from your current project file to the 'Global.mpt' template so it becomes available in all your projects.
