![]() ![]() Change Status Date to Current Date if you haven’t set a Status Date. The Flag field (Flag20) formula for a 14-day or 2-week lookahead is shown below. Level 2 is the key stage of this project. ![]() The lowest levels represent the project deliverables, and all activities and tasks will be grouped under these lowest levels. I have a google sheet addon, with custom formulas that fetch data from my API, I built a refresh mechanism to force the formulas to execute again to get updated data, but I want only specific formulas to refresh and not not every cell in the spreadsheet. This example of a work breakdown structure for a construction project demonstrates that all the elements are listed under the WBS levels. Won’t it be nice if we could set up a rolling date filter for our lookahead just like you would in Primavera P6, so that instead of hard dates, we can define our lookahead window as Status Date + 14 days or Current Date + 14 days for a 2-week lookahead?Īt the end of this video, you would learn how to set-up a rolling date filter in Microsoft Project using Flag custom field and how to save the filter to a Global Template so that it is available to you in other Microsoft Project files. Advertising Reach developers & technologists worldwide About the company. It sometimes becomes frustrating when you are always prompted to select the dates for a lookahead filter. The default lookahead filter in Microsoft Project, Date Range filter, only allows one to choose two hard dates for the start and end dates of the lookahead period. ![]()
0 Comments
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |