Parent Function

ukuri

I am using a helper column to show the "parent" of each row. However, the problem is that some rows are indented more than once, so they have multiple "parents". Currently, the system shows the most immediate "parent" row( for example AM#1 Shows "Account manager"). However, I wish to show the highest level parent in the hierarchy ( for example, AM#1 to show "Key Hires")

Andrée Starå

Hi,

Do you only want to show the top level?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

L_123

=INDEX(ANCESTORS([Task Name]5), 1)

 

Change the 1 to reflect which level you want to reference.

ukuri

This works great! Thank you

 

Kristine Candela

You can also combine the JOIN and ANCESTORS functions:

=JOIN(ANCESTORS(Task@row), ": ")

Where Task is the name of your Primary column and you follow the comma with whatever delimiter text you would like, if any.

Formula Returns: Level1 Parent: Level2 Parent: Level3 Parent, etc..

This option pulls all ancestors without having to specify the level, so is simpler when you have multiple tiers.

Regards,

Kristine