PING: MS Project Gurus

wade moore · 02-07-2008, 08:52 AM

I'm creating a custom filter. I want to not have to edit it every week that we meet to talk about the project.

What I want is to be able to have a filter that says for instance : Finish Date < Today

Or Start Date < Today +14 Days

Is that possible? I know how to do a custom filter and hard code the date, but not how to make it know what today is.

MacroGuru · 02-07-2008, 10:35 AM

Wish I could help, I started using Gantt Project, one as a money saver and two, because it isn't as resource heavy...I will see if it can do what you are asking.

flere-imsaho · 02-11-2008, 05:47 PM

Sorry if this is a bit vague, but I don't have Project on my home computer, and I don't have access to my work computer right now. If it makes no sense, pm me and we can take it to email.

First thing is to insert a new column. Insert the column "Date1" which is one of those generic fields you can customize around a specific data point (date in this case).

Next, right-click on the column to customize it. Here you want to customize via formula, and just use the drop-downs so the value = today's date, which is either "Date" or "Now", I can never remember. Should be easy to figure out.

Then you can go ahead and create your custom filter using the "Date1" column/field as your reference for today's date.

wade moore · 02-11-2008, 06:44 PM

You rule. Makes sense, I'll try it at work tomorrow!

wade moore · 03-14-2008, 07:21 AM

Quote:

Originally Posted by flere-imsaho

Sorry if this is a bit vague, but I don't have Project on my home computer, and I don't have access to my work computer right now. If it makes no sense, pm me and we can take it to email.

First thing is to insert a new column. Insert the column "Date1" which is one of those generic fields you can customize around a specific data point (date in this case).

Next, right-click on the column to customize it. Here you want to customize via formula, and just use the drop-downs so the value = today's date, which is either "Date" or "Now", I can never remember. Should be easy to figure out.

Then you can go ahead and create your custom filter using the "Date1" column/field as your reference for today's date.

Finally got to doing this.

Works like a charm - thanks a ton!!!

flere-imsaho · 03-15-2008, 05:32 PM

02-07-2008, 10:35 AM	#2
MacroGuru Coordinator Join Date: May 2003 Location: Utah	Wish I could help, I started using Gantt Project, one as a money saver and two, because it isn't as resource heavy...I will see if it can do what you are asking. __________________ "forgetting what is in the past, I strive for the future"

02-11-2008, 05:47 PM	#3
flere-imsaho Coordinator Join Date: Sep 2004 Location: Chicagoland	Sorry if this is a bit vague, but I don't have Project on my home computer, and I don't have access to my work computer right now. If it makes no sense, pm me and we can take it to email. First thing is to insert a new column. Insert the column "Date1" which is one of those generic fields you can customize around a specific data point (date in this case). Next, right-click on the column to customize it. Here you want to customize via formula, and just use the drop-downs so the value = today's date, which is either "Date" or "Now", I can never remember. Should be easy to figure out. Then you can go ahead and create your custom filter using the "Date1" column/field as your reference for today's date.

03-15-2008, 05:32 PM	#6
flere-imsaho Coordinator Join Date: Sep 2004 Location: Chicagoland

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)