Solved

MS Project 2003 - Custom Filter To Show Potential Late Tasks

Posted on 2010-11-29
6
751 Views
Last Modified: 2012-05-10
Hello,

Hoping someone can assist.  I need to create a custom filter that will only show tasks with finish dates that are within 2 weeks of the current (today) date.  The objective is when the filter is ran it will alert the end user of tasks that are quickly approaching their finish date within the next two weeks.  Please reference the attached image.

Thanks!
MS-Project.jpg
0
Comment
Question by:Escanaba
  • 3
  • 3
6 Comments
 
LVL 4

Expert Comment

by:EFernandes
Comment Utility
If I understood correctly, this should help you: http://blogs.techrepublic.com.com/tech-manager/?p=3309
0
 
LVL 1

Author Comment

by:Escanaba
Comment Utility
Unfortunately this does not help.  The link shows how to set it up based on the existing criteria shown in the example but not to how my file is set up.  I would need someone to provide how to set the filter up in a way that will do what I need it to do.
0
 
LVL 4

Expert Comment

by:EFernandes
Comment Utility
You could insert the column "Remaining duration" and auto filter to 15 days or customize the filter to "2w"
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 1

Author Comment

by:Escanaba
Comment Utility
Keeping in mind I know very little of MS Project...I know how to insert a column and how to start setting up a custom filter.  What are the parameters/formula that would need to be entered so that it filters 2 weeks?
0
 
LVL 4

Accepted Solution

by:
EFernandes earned 500 total points
Comment Utility
Ok. Sorry.

1st - Insert the column "Remaining duration"
2nd - Press the "auto-filter" icon (or go to the menu Project -> Filtered for -> Auto-filter
3rd - Notice that a small arrow shows up on every column. Press the arrow on the "Remaining duration" header
4th - Select the "(Custom)" option
5th - On the 1st combo box select "is less than or equal to"
6th - On the other combo box (on the right side) write the condition (15d - to show the tasks that have less or equal to 15 days of remaining duration; 2w - to show the tasks that have less or equal to 2 weeks of remaining duration)
7th - Click "ok" and you're done!
0
 
LVL 1

Author Closing Comment

by:Escanaba
Comment Utility
That worked.  Sorry for the delay.  Thank you!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now