MS Project 30 60 90 day lookahead

%3CLINGO-SUB%20id%3D%22lingo-sub-135310%22%20slang%3D%22en-US%22%3EMS%20Project%2030%2060%2090%20day%20lookahead%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-135310%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20am%20new%20to%20Project%20Management%20as%20I%20have%20started%26nbsp%3Ba%20new%20role%20as%26nbsp%3Ba%20Project%20Lead%20and%20this%20is%20all%20new%20to%20me%20coming%20from%20a%20tester%20background.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20been%20tasked%20with%20finding%20a%20way%20on%20MS%20Project%20to%20show%20tasks%20that%20are%20due%20in%2030%2060%20and%2090%20days%2C%20however%20I%20have%20no%20ideas.%20I%20was%20wondering%20if%20anyone%20has%20a%20way%20of%20doing%20this%20on%20a%20existing%20project.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eany%20other%20advice%20is%20welcome...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%20All!!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYash%20Dutt%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-333974%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Project%2030%2060%2090%20day%20lookahead%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333974%22%20slang%3D%22en-US%22%3E%3CP%3Edidn't%20work.%26nbsp%3B%20any%20hints%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-201233%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Project%2030%2060%2090%20day%20lookahead%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201233%22%20slang%3D%22en-US%22%3E%3CP%3EYas%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20do%20a%2030%2C%2060%20day%20look%20up%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20this%20flag%20and%20view%20for%20a%26nbsp%3B4%20week%20look%20ahead%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20a%20Flag%20custom%20field%20with%20the%20following%20formula%20(you%20can%20change%20the%204%20weeks)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIIf((%5BStart%5D%26gt%3B%3DDateAdd(%22ww%22%2C-1%2C%5BStatus%20Date%5D)%20And%20%5BStart%5D%26lt%3B%3DDateAdd(%22ww%22%2C4%2C%5BStatus%20Date%5D))%20Or%20(%5BFinish%5D%26gt%3B%3DDateAdd(%22ww%22%2C-1%2C%5BStatus%20Date%5D)%20And%20%5BFinish%5D%26lt%3B%3DDateAdd(%22ww%22%2C4%2C%5BStatus%20Date%5D))%2CYes%2CNo)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%224%20week%20look%20ahead.PNG%22%20style%3D%22width%3A%20642px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35472iD9782D502CBB32D8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%224%20week%20look%20ahead.PNG%22%20alt%3D%224%20week%20look%20ahead.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Visitor

Hi All,

 

I am new to Project Management as I have started a new role as a Project Lead and this is all new to me coming from a tester background.

 

I have been tasked with finding a way on MS Project to show tasks that are due in 30 60 and 90 days, however I have no ideas. I was wondering if anyone has a way of doing this on a existing project.

 

any other advice is welcome...

 

Thank you All!!

 

Yash Dutt

2 Replies
Highlighted

Yas

 

You can do a 30, 60 day look up

 

I use this flag and view for a 4 week look ahead

 

Create a Flag custom field with the following formula (you can change the 4 weeks)

 

IIf(([Start]>=DateAdd("ww",-1,[Status Date]) And [Start]<=DateAdd("ww",4,[Status Date])) Or ([Finish]>=DateAdd("ww",-1,[Status Date]) And [Finish]<=DateAdd("ww",4,[Status Date])),Yes,No)

 

4 week look ahead.PNG

 

Highlighted

didn't work.  any hints?