Forum Discussion
Solved
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
I have Text1 Field with text values "1", "1.2", "1.3", "1.3.4". Can I group by this field with hierarhy view?
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
- No, I need group Text1 by Hierarchy (by WBS). There is no WBS in list for grouping.
- Okay, I'm confused. You said the Text1 field but now you seem to be referring to the WBS field. So which is it? A screen shot might clear up some misunderstanding.
You could try this. Create a formula for the Text1 field that simply replicates the WBS field. Then group by Text1.
JohnHello, John
Screenshot here