Hi Everyone!
I have a parent hierarchy similar to the table below.
List | Top Level | Parent Hierarchy |
H2 | H1 | |
H3 | | H2 |
H4 | | H3 |
What I am trying to achieve is a text formatted line item that will show the name of each individual list member (I am struggling with multiple parent members). I need the output similar to the table below.
Even though I can indicate that if it is H1 give me H1, give me H4 when it is a child member, but I failed to formulaically distinguish between H3 and H2.
| List Item Name TEXT |
H4.18 | H4.18 |
H4.17 | H4.17 |
H4.16 | H4.16 |
H4.15 | H4.15 |
H3.e | H3.e |
H4.14 | H4.14 |
H4.13 | H4.13 |
H4.12 | H4.12 |
H4.11 | H4.11 |
H4.10 | H4.10 |
H4.9 | H4.9 |
H3.d | H3.d |
H4.8 | H4.8 |
H4.7 | H4.7 |
H3.c | H3.c |
H4.6 | H4.6 |
H4.5 | H4.5 |
H3.b | H3.b |
H2.c | H2.c |
H2.b | H2.b |
H4.4 | H4.4 |
H4.3 | H4.3 |
H4.2 | H4.2 |
H4.1 | H4.1 |
H3.a | H3.a |
H2.a | H2.a |
H1 | H1 |
Thank you in advance!