Forum Discussion

Vasily_Zaytsev's avatar
Vasily_Zaytsev
Iron Contributor
Sep 02, 2021
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

 

  • John-project's avatar
    John-project
    Sep 03, 2021

    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

  • John-project's avatar
    John-project
    Silver Contributor
    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
    • Vasily_Zaytsev's avatar
      Vasily_Zaytsev
      Iron Contributor
      I have Text1 Field with text values "1", "1.2", "1.3", "1.3.4". Can I group by this field with hierarhy view?
      • John-project's avatar
        John-project
        Silver Contributor

        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

Resources