Home

MS Project 30 60 90 day lookahead

yash dutt
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

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

 

didn't work.  any hints? 

Related Conversations
Reporting on Project Online (PWA) Timesheets
Andy Dennis in Project on
3 Replies
Add, Edit, Delete Project Online data using Excel
MonteStJohns in Project on
5 Replies
Add Project Online to a Modern site collection
Eric Deferm in Project on
1 Replies
Migrate from Project Server 2013 to Project Online
Adullah_Ismail in Project on
1 Replies
Summary task doesn't consider sub task dates
Kateraid in Project on
1 Replies