#1
|
|||
|
|||
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. |
#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 Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MS Project 2013_3 Shift Look ahead | Aagent87 | Project | 9 | 12-02-2014 09:24 AM |
Week by week report | thedeadzeds | Excel | 3 | 11-16-2013 02:06 AM |
5 days/week during planning & 7 days/week during implementation | sanlen | Project | 1 | 06-25-2012 04:17 PM |
Conditional Formatting per Week | mrgy05 | Excel | 2 | 06-07-2012 10:38 AM |
How to reorder the days of the week | Mosey | Outlook | 2 | 10-31-2011 06:47 AM |