Hierarchy question

Mgamache88

I wish to create a column that includes the Hierarchy and the task name. I want this for a couple reasons, but 1 is so that when I select this column as my gantt display each bar will have a full description of the task.

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

Paul Newcome

Ah. In that case you would use the same JOIN/ANCESTORS formula and then "add" the task name to the end.

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

Paul Newcome

It looks like your formula is working as you describe wanting it to work. Is there some issue you need help with, or are you just making a comment to try to help others out?

Mgamache88

Thanks for your reply Paul, it is working as its supposed to, but it doesn't quite do what I want. This formula will put all the ancestors of a cell into the task hierarchy cell but will not include the cell itself(Task Name)

ie. I would like row 3 of Task Hierarchy to read

Zone 1, HYGIENE ROOM - AIR DRYER HALLWAY, PVC, PVC Liner

instad of

Zone 1, HYGIENE ROOM - AIR DRYER HALLWAY, PVC

Ive tried a few variations of =JOIN((ANCESTORS([Task Name]@row),[Task Name]@row) ", ")

But just get various errors.

Paul Newcome

Ah. In that case you would use the same JOIN/ANCESTORS formula and then "add" the task name to the end.

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

Mgamache88

This works perfectly, thanks paul.

Paul Newcome

Happy to help. 👍️