• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 788
  • Last Modified:

MS Project 2003 - Custom Filter To Show Potential Late Tasks

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
Escanaba
Asked:
Escanaba
  • 3
  • 3
1 Solution
 
EFernandesCommented:
If I understood correctly, this should help you: http://blogs.techrepublic.com.com/tech-manager/?p=3309
0
 
EscanabaAuthor Commented:
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
 
EFernandesCommented:
You could insert the column "Remaining duration" and auto filter to 15 days or customize the filter to "2w"
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
EscanabaAuthor Commented:
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
 
EFernandesCommented:
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
 
EscanabaAuthor Commented:
That worked.  Sorry for the delay.  Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now