Forum Discussion
Filter Creation
vincentcbv,
I'm a little confused. The built-in filter "In Progress Tasks" shows all tasks that have started but are not finished (i.e. "in progress"). That is what you are asking for. So what additional tasks are you expecting your dynamic filter to show?
Perhaps a screen shot example would help.
John
The “In Progress Tasks” filter relies on the Actual Start and Actual Finish fields, but I’m using Start and Finish instead. Because of this, the default filter won’t work if Actual Start is blank or Actual Finish has a date.
My custom filter highlights tasks correctly—where Start is in the past and Finish is in the future—but it uses a static “today” date. This means I have to manually update the filter’s value each day for it to work.
- In Progress Tasks filter
The “In Progress Tasks” filter relies on the Actual Start and Actual Finish fields, but I’m using Start and Finish instead. Because of this, the default filter won’t work if Actual Start is blank or Actual Finish has a date.
My custom filter highlights tasks correctly—where Start is in the past and Finish is in the future—but it uses a static “today” date. This means I have to manually update the filter’s value each day for it to work.
Charlie
Charlie,
I see the tasks you are highlighting, but they are NOT "in progress" tasks. They are tasks that should have started but did not start as planned. So again, what exactly are you trying to show?
Note there are several other built-in filters for unstarted tasks (e.g. "Late tasks", "Should start by", "Slipping tasks", "Date Range", etc.).
So okay, whatever your goal, here is one way to do an "end around run" with Project's "fussy" filtering. Try these steps.
- Create a custom Flag field with the following formula: Flag1 = IIf([Start]<={Current Date], "yes","no")
- Filter on the Flag1 field
Here's an example
And this is what results when the filter is applied
Another option is to use an interactive filter like this
Hope this helps,
John
