Forum Discussion
Filter Creation
PlannersPlace,
Unless I'm missing something, this does the same thing as the built-in "In Progress Tasks" filter.
John
John,
You are right, it does the same thing as the built-in in-progress tasks filter.
Thank you PlannersPlace and John-project for taking the time to respond. However, PlannersPlace's filter uses % Complete, and I don't plan to update that field.
Also, the built in In Progress Tasks filter uses the Actual Start and Actual Finish fields, which I don't plan to update. I want to use Start and Finish, but when I edit the In Progress Task filter and change the field names to Start and Finish, it doesn't highlight or filter. If you don't mind, give it a shot on your end and see if you get a different result.vincentcbv,
Let's back up just a bit and get some clarification. What exactly do you define as "in progress" tasks"? And if you are not updating via % complete or actual start and actual finish, how are you updating?
Just for reference let me clarify something. When progress starts on a task, there are a couple ways to indicate it has started. An entry either directly into the % Complete field or via the Update Project (or similar) will automatically copy the start date into the Actual Start field (i.e. the task started as planned). Alternately, if the task did not start as planned, an entry is made directly into the Actual Start field and that will automatically update the Start field to adjust the plan to reality. The original plan would have been captured by setting a baseline. So, I'm wondering what you are tracking?
But to answer your question about substituting Start and Finish for Actual Start and Actual Finish in the In Progress Tasks filter, the Start and Finish fields will ALWAYS have a date so the modified filter won't filter anything because all tasks will show.
John
I want to define "in progress" as the Start Date is before today and the Finish Date is after today. In other words:
Start Date <=Today, and Finish Date >=Today.I don't want to use the % Complete, Actual Start or Actual Date fields. But it's not looking like I can create a custom filter that will calculate based on Start/Finish Dates. I'll probably have to use % Complete so it will add a value in the Actual Start/Actual Finish Date fields.
