Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

2week look ahead

6 replies [Last post]
Mon, 2008-05-19 05:24
Alex Logie
User offline. Last seen 15 years 47 weeks ago. Offline
Joined: 21 Jan 2008
Posts: 6
Groups: Civil Engineering
Dear Planners,

is there an easy way to show 2wk look ahead in Microsoft Project?




cheers

Nigel
Top

Replies

Tue, 2016-08-23 12:13
#1
Sid ahmed FARES
User offline. Last seen 7 years 22 weeks ago. Offline
Joined: 30 Sep 2013
Posts: 3
Groups: None

Hello,

 

Therre is a formulas for showwing the name of sucessor or predecessor filed in Ms-project spreedsheat.

Regards

FARES

Top
Mon, 2008-05-26 21:54
#2
Trevor Rabey
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
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 can’t 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.
Top
Mon, 2008-05-26 18:30
#3
Alex Logie
User offline. Last seen 15 years 47 weeks ago. Offline
Joined: 21 Jan 2008
Posts: 6
Groups: Civil Engineering
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)?

I’m not getting it right.


Cheers

Top
Tue, 2008-05-20 02:57
#4
Trevor Rabey
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
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]

Top
Mon, 2008-05-19 06:38
#5
Darren Kosa
User offline. Last seen 7 years 10 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
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
Top
Mon, 2008-05-19 05:30
#6
Anoon Iimos
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
as far as I know, there is no "Data Date Line" in MSP (i don’t know the latest versions)
Top