Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-03-2016, 12:18 PM
ebilbrough ebilbrough is offline 2 Week Look Ahead Filter Windows 7 32bit 2 Week Look Ahead Filter Office 2013
Novice
2 Week Look Ahead Filter
 
Join Date: Nov 2015
Location: Austin, TX
Posts: 19
ebilbrough is on a distinguished road
Default 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.
Attached Images
File Type: png With Summary.png (52.7 KB, 18 views)
File Type: png Without Summary.png (35.9 KB, 15 views)
Reply With Quote
  #2  
Old 03-06-2016, 04:36 PM
Guloluseus Guloluseus is offline 2 Week Look Ahead Filter Windows 7 64bit 2 Week Look Ahead Filter Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft