![]() |
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
I assume MSP13 is similar yo MSP10, but havent used it os this may be a little off.
If you og to your filters, use the dropdown, click on "more filters". Select the filter you created (click on it) and from the right choose "edit". There should (again, this is in 2010) be a tickbox bottom right that says "show related summary rows". Untick it and save, that should do it. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Aagent87 | Project | 9 | 12-02-2014 09:24 AM |
![]() |
thedeadzeds | Excel | 3 | 11-16-2013 02:06 AM |
![]() |
sanlen | Project | 1 | 06-25-2012 04:17 PM |
![]() |
mrgy05 | Excel | 2 | 06-07-2012 10:38 AM |
![]() |
Mosey | Outlook | 2 | 10-31-2011 06:47 AM |