How can I create Grouping by Text Field in MS Project?

[Vasily_Zaytsev]

Hello.

How can I create Grouping by Text Field in MS Project like a substitution table?

BR, Vasily

[#2]

Vasily_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

[#3]

I have Text1 Field with text values "1", "1.2", "1.3", "1.3.4". Can I group by this field with hierarhy view?

[#4]

@Vasily_Zaytsev 

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

[#5]

No, I need group Text1 by Hierarchy (by WBS). There is no WBS in list for grouping.

[#6]

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.

John

[#7]

Hello, John

Screenshot here

[#8]

Vasily_Zaytsev,
So, are you saying you got what you wanted? If not, please elaborate on what is missing. If so, please consider marking my response as the answer.
John

[#9]

Hello, John.
But I can't group hierarchycally as I show on my screenshot. If I select Group by Text1, I have only ascending grouping.
Is it possible in MS Project. If not, please write about it.
BR, Vasily

[#10 · Accepted solution]

@Vasily_Zaytsev

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