I searched the previous posts for this topic, but didn't really see anything. I apologize if this has been covered somewhere else. Essentially, we are trying to create a task report that shows which active tasks have been In Progress for longer than their planned duration.
So here's my (2-part) challenge, in case anyone is up for it?
Part 1: A few weeks ago, someone had inquired about reporting on the number of days a project has been open. Along the same lines, Is there a way to add a column to a task report that would display the number of days an active task has been in the In progress state? I don't think the Task Actual Duration field would work here because the task would still be active.
Part 2: Assuming that there is an answer for Part 1 --- How would you set the report filter to show only those tasks where the number of days In Progress is longer than the task planned duration? So for example, a planned duration for a task might be 2 days. If the task has been In Progress for 3 days, then it would appear on the report.
Thanks in advance!
Victor Victor Mendez MFS Investment Management