| Hold on… (Samuel L Jackson – Jurassic Park)This process is just a starter to achieve the same thing, more complex conditions can be built. The high-level steps are:
1. Create a Custom Flag in Project
2. Add a formula for tasks Starting (or Finishing) between certain dates
3. Filter the view
Note: This is meant to get you up and running so I’ve left out some of the more complicated activities that may generate follow-up questions e.g. how do I automatically update the formula.
1. Create a Custom Flag In MS Project
This is real easy 🙂
- In the Gantt view, right-click any column and “Insert Column”
- When the list of Columns appears select one of the FLAG columns. I’ll select Flag9 (TIP: you can start typing the name of the column to save scrolling)
2. Add a formula for tasks starting (or Finishing) between certain dates
This is not hard but just a few more steps
- Right-click Flag9 (where you see Flag9, substitute the name of your Flag choice)
- Select Custom Fields
- When the Custom Fields dialog appears make sure the Radio Button at the top is on Task (if not make sure you are in the Gantt View)
- In the Type combo box select Flag
- The Field list will now show Flag1 through to Flag20
- Select Flag9
- Click the Rename button type the name you’d like to see in the Gantt view I’m going to call mine “Starting This Week”
- Select OK to close the dialog.
- In the Custom Attributes section select Formula…
- In the formula box paste the following line.
IIf([Start]>#19/04/2015# And [Start]<#25/04/2015#,Yes,No)
NOTE: This is for UK date format so shows dd/mm/yyyy. Change this to the date format for your region e.g. USA mm/dd/yyyy.
Also note the use of > and not >= which introduces problems associated with task time.
What does that do????
This formula will find tasks with a Start date greater than 19/04/2015 but less than 25/04/2015 or in English, “tasks starting between Mon 20th April and Fri 24th Apr”.
What does the different parts mean?
IIF – IIF(expression, true part, false part)
[Start] – This represents the Start column in the Gantt view
#19/04/2015# – This is the date at the start of the period I’m interested in checking
#25/04/2015# – This is the date at the end of the period I’m interested in checking.
- Click OK to accept the formula
- In the section below headed Calculation for task and group summary rows, select “Use formula“
- Now Click OK to close the Custom Fields dialog box.
Your Custom Field () should now have a bunch of Yes & No’s showing according to the rule you just applied. In this example all tasks with a Start Date in the week of Mon 20th April 2015- Fri 24th Apr 2015 will be flagged with a YES including summary tasks.
3. Filter the view
In the Gantt view select the Auto-Filter drop-down button in the Column headed “Starting This Week” (renamed from Flag 9 above) and uncheck “No” to filter the tasks in the Gantt view.
That’s great but what about the “NO”‘s that are still showing for Summary Rows?
If there are some NO’s still showing those are a by-product of a Filter allowing “Related Summary Rows” to be shown. To change than setting create a Custom Filter (see the View Ribbon, Data Tab, Filter dropdown. Create a New Filter with the Flag9 column and ensure the option “Show related summary rows” is unchecked.).
Finally some polish,
To check for Tasks Finishing this Week use the formula:
IIf([Finish]>#19/04/2015# And [Finish]<#25/04/2015#,Yes,No)
In a later post I’ll show how you can automate the date selection to the current week.