Forum Discussion
Vasily_Zaytsev
Sep 02, 2021Iron Contributor
How can I create Grouping by Text Field in MS Project?
Hello.
How can I create Grouping by Text Field in MS Project like a substitution table?
BR, Vasily
Okay, then why not simply sort by Outline Level. This structure:
Gives this result:
If that doesn't work for you (i.e. you really, really, really need the grouping format), then it can be done with something like this:
But if you absolutely just have to have a pure grouping format of the Text1 (e.g. WBS) field, then that can be done with some VBA.
Wow, so many options. I'm sure your head is spinning.
John
- John-projectSilver ContributorVasily_Zaytsev,
Sorry, I don't quite understand your question. Grouping by any field is a simple matter of using the "group by" settings. What exactly do you mean by, "like a substitution table"? An example might help to explain.
John- Vasily_ZaytsevIron ContributorI have Text1 Field with text values "1", "1.2", "1.3", "1.3.4". Can I group by this field with hierarhy view?
- John-projectSilver Contributor
Okay, let's say you have something like this:
And now group by the Text1 field in ascending order. This is the result:
Is that what you want? If not, please provide a more detailed description with a screen shot.
John