Hierarchy question
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), ", ")
Best Answer
-
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
Answers
-
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?
-
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.
-
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
-
This works perfectly, thanks paul.
-
Help Article Resources
Categories
Check out the Formula Handbook template!