Microsoft Project Interactive Filters

Interactive Filters

Interactive filters allow you to provide the comparison data at the point of running the filter and so can be changed every time the filter is run.

There are several interactive filters set up as standard within Microsoft Project. They are displayed with … at the end of the name of the filter.

When an interactive filter is run, rather than just finding the tasks that meet the criteria being shown, the dialog box asking for the comparison data is displayed instead.

Once the data is provided the filter then works as any other filter.

The parameter in the value column is what makes it into an interactive filter.

The format of the parameter is

“Question text”?

The question can be phrased in any way, the text itself is not important – it is the field name and the test that control the filter. The text cannot start with a space or be a field name by it self (it could be a field name with some other text added at the end).

The question needs to be enclosed with in double quotes and have a question mark at the end.