Formula for different levels

Occasional Contributor

Formula for different levels



I have a list which is a Flat list but has different levels(Note- we cannot make it as a hierarchy, it has to be a Flat list).


List has list items like below.(Column A). And Line items Column B,C,D. Here, Asia and Europe are at top most level(level 1). They have child items like 1.1 China,2.1 France etc. Similarly China has a child like 1.1.2 Beijing and so on.


In my line items (Level 1 parent-Column B, Level 2 parent-Column C, Level 3-Column D), I want to write formulas such that I can get the List items in each level. Exactly as below. Note, Suppose in Future I add more list items  like 3. America , 4.Canada. this should still work. Please can anyone help me as early as possible on this.








Master Anaplanner/Community Boss

Hello @Rajasekhar 

Check this article out

It might be more than you need right now, but perhaps you can get some ideas

"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"

Dear community members
Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for