MS Project - Create Unique Group By Filter

[DDPMF]

My organization has requested the use of a given schedule template to be used for all projects. As a result, this template will be used for multiple sub projects that will be contained in master project.

I’m trying to develop a group filter to apply to the master project which will identify the standard events, accomplishments, and criteria (tasks) for all sub projects contained in the master project so there will be a custom view to see all tasks (criteria) .

I’m at a very novice level when it comes to creating formulas in MSP, but this is what I developed thus far to get me started. Based on the template, the events are at outline level 2, accomplishments are at outline level 3, and the criteria is at outline level 4.

Using the Text 27 field [Events], I created the following formula:

IIf([Outline Level]=2,"02 - Event" & " " & [Name]," ")

Using the Text 28 field [Accomplishments], I created the following formula:

IIf([Outline Level]=3,"03 - Accomplishments" & " " & [Name]," ")

Using the Text 29 field [Phase], I created the following formula:

IIf([Outline Level]=4,"04 - Criteria" & " " & [Name]," ")

I then created a Grouping Filter to Group By Event [Text27], Acc [Text28], Criteria [Text29].

To conduct a test I opened my master project and applied the Group By Event filter. Unfortunately, my test failed since the result of the formula only applied the result of the formula at either outline level 2, 3, or 4, whereas I believe result of the formula needs to be applied to all task for either Text fields 27, 28, or 29. Can anyone help or provide another approach to accomplish the desired result?

 

[SkipVought]

Hi,

Try forum913

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}