Can you create a 2 week look ahead schedule filter in a master project file?

Lenny_D1,

Yes, master projects can be filtered just like any project. Please show us your filter and any customized fields associated with it.

In this example I created a simple filter as you described with a custom field (Date1) that calculates a date 14 days from the current date.

This is a dynamic master with two tasks of its own and a simple subproject inserted

Now I apply the filter at master level.

John

Lenny_DI,

I think you mean "status date + 14 days".

Wouldn't you be better off copying the built-in date range filter and replacing the questions with the dates?

Hi John,

So I have a customized field with the following formula:

And currently have my project status date set to 6/12, however, all of the rows in the 2w LAH column I created are still listed as 'No':

I was hoping, by creating the customized field, I wouldn't have to keep resetting the 'date filter' that is pre-programmed.

Could you share how you have your customized field set up for [Date 1]?

Thanks!

too many brackets in your formula. This works:

IIf(Start<([Status Date]+14) And [% Complete]<100,"Yes","No")

Lenny_Dl,

Nothing wrong with your custom field formula but it does have redundant parenthetical groups. A better construct would be:

Flag1 = IIf([Start]<([Status Date]+14) And [% Complete]<100,"yes","no")

However, I'm wondering if you customized Flag1 with the same formula at just master level. If you have the formula at subproject level, all subproject tasks will respond to the formula and the result will be visible at master level. If you only have the formula at master level, it will only apply to tasks that actually belong to the master. In this example I've used what I assume is your second subproject and inserted it into a master that also has 3 tasks. Since there are tasks at both master and subproject level, the Flag1 field needs to be customized at both levels. The Status Date at master level is 6/12/23. To help visualize the 14 day look ahead, I also created a custom date field with this simple formula

Date1=[status date]+14

John