There are a number of ways to achieve this. This simplest assumes each of the task descriptions is the same for each “Phase C”. Go to Project, Filtered For, AutoFilter. You will now have an arrow in each of your column titles. Click on the Task Name arrow and select “Phase C”, you will have only phase C subtasks.
If the descriptions are different, but include the phrase “Phase C” then click the arrow, Custom, select “contains” on the left, and enter Phase C on the right – this assumes you are absolutely consistent in your data entry.
I prefer to use one of the Text Fields to achieve this kind of summary. Insert a text column – right click the title area, insert column, field name, choose text1 and enter. Now right click on the text1 column and choose customize fields, choose “text” in the top right and rename – “Phase” would be appropriate, (or “Lifecycle Phase” if others have different definitions of what a phase is). Fill in an “A” for each phase A, “B” for each Phase B etc. It is time consuming but worth it.
Go to Project Group by, More Groups, New, name it “*1 Phase” set the first level to “Phase” or whatever you named the text field to, set the back color, font style etc, and apply. It is now grouped by Phase with a title of A, B, C etc. You could enter “Phase A”, “Phase B” etc instead of just A, B, C. You could further explore the Value list option of the Custom Text field…
To select just one phase create a filter:
Go to Project, Filtered For, More Filters, New, name it “*1 Phase A” set the condition to Phase = A and save it, apply.
Member for
22 years 7 monthsRE: Sorting by Subtasks.
There are a number of ways to achieve this. This simplest assumes each of the task descriptions is the same for each “Phase C”. Go to Project, Filtered For, AutoFilter. You will now have an arrow in each of your column titles. Click on the Task Name arrow and select “Phase C”, you will have only phase C subtasks.
If the descriptions are different, but include the phrase “Phase C” then click the arrow, Custom, select “contains” on the left, and enter Phase C on the right – this assumes you are absolutely consistent in your data entry.
I prefer to use one of the Text Fields to achieve this kind of summary. Insert a text column – right click the title area, insert column, field name, choose text1 and enter. Now right click on the text1 column and choose customize fields, choose “text” in the top right and rename – “Phase” would be appropriate, (or “Lifecycle Phase” if others have different definitions of what a phase is). Fill in an “A” for each phase A, “B” for each Phase B etc. It is time consuming but worth it.
Go to Project Group by, More Groups, New, name it “*1 Phase” set the first level to “Phase” or whatever you named the text field to, set the back color, font style etc, and apply. It is now grouped by Phase with a title of A, B, C etc. You could enter “Phase A”, “Phase B” etc instead of just A, B, C. You could further explore the Value list option of the Custom Text field…
To select just one phase create a filter:
Go to Project, Filtered For, More Filters, New, name it “*1 Phase A” set the condition to Phase = A and save it, apply.