List Ancestors

MLK

Does anyone have a way to list the ancestors of a row in a cell of that row? Thanks!

Ray Lindstrom

Hi @MLK,

Try this:

=JOIN(ANCESTORS([Task Name]@row), ", ")

Replace [Task Name] with your Primary Column name.

Optionally you can replace the ", " with another delimiter.

Hope it helps!

BRgds,

-Ray

Darren Mullen

@MLK what about the ancestors do you want to list? Task name?

MLK

@Ray Lindstrom Worked perfectly. Thanks!!!

Ray Lindstrom

@MLK,

Glad to hear it, and happy to help!

All the best,

-Ray

Ray Lindstrom

@MLK,

One more thought. Here's the other delimiter that I would consider. It gives a space, a dash, and a space in between each Ancestor.

=JOIN(ANCESTORS([Task Name]@row), " - ")