2 Week Look Ahead Filter
I've created a 2 Week Look Ahead filter that identifies those tasks that will or are being worked in the next 2 weeks.
I've started by creating a custom date field (2WL) that is a formula (Current date + 14).
My filter is:
(Field Name) Scheduled Start (Test) is less than or equal to (Value) 2WL.
The result of this filter displays those individual tasks that have a scheduled start date equal to or less than 2 weeks from today. Unfortunately it also displays Summary Level tasks (but not the detail tasks) whose work begins beyond the 2 week window.
When I edit my formula to:
(Field Name) Scheduled Start (Test) is less than or equal to (Value) 03/17/16
It gives me the result I'm looking for - no summary tasks.
Any thoughts on how I can make this filter work with no summary tasks and not requiring editing the date each time?
Note:I've attached 2 images showing the results. Also my filter includes several other lines relating to % complete and active tasks. These lines have no bearing on the results.
|