2week look ahead
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Hello,
Therre is a formulas for showwing the name of sucessor or predecessor filed in Ms-project spreedsheat.
Regards
FARES
Insert/show the Date1 field.
Right-Click on the heading of the Date1 column.
Click Customise Fields on the menu.
First Rename the Date1 field.
Call it "S Date" or similar, but you cant use "Status Date" because that is a reserved name.
Then write the formula which just consists of one function, which is the Status Date.
You can just type it or get it from the list of functions with the function button.
[Status Date] is the last one under Project, Date.
Thanks Trevor,
could you please elaborate on this
"Use a spare Date field, Date1, to store the Status Date.
Tools, Customise Fields, then Formula and Status Date is in Function,Project."
is it Function===>Project===>ProjDateValue(expression)?
Im not getting it right.
Cheers
Say we want the look-ahead to be 3 weeks ahead of the Status Date.
You can do the same thing similar for the Current Date.
Use a spare Date field, Date1, to store the Status Date.
Tools, Customise Fields, then Formula and Status Date is in Function,
Project.
Use another spare Date field, Date2, to store the [Status Date] +21
Once you have the boundaries of your date range stored in fields you can
make a Filter which is similar to the built-in Date Range Filter but which
gets its data from the fields instead of user input.
Make a Filter called "AA 3 Week Look-ahead".
Project, Filtered For, More Filters, New.
Filter like this:
Tasks whose Start is less than or equal to [Status Date] +21
And
Tasks whose Finish is greater than or equal to [Status Date]
Hi Alex,
In the past I have used a Date Range filter (or an adaptation) to achieve this. However, this shows the filtered tasks with their complete durations, regardless of the fact only a portion of the task happens during the timeframe specified in the Date Range filter.
For a quick view this is sometimes all you need, but you can also use the timescale option when printing to narrow down the field of view, so it just prints the two week window.
Regards,
Darren
as far as I know, there is no "Data Date Line" in MSP (i dont know the latest versions)