This video gives a demonstration of using the ANCESTORS() and PARENT() functions to reference multiple levels of hierarchy. As promised in the video, here are the formulas:
Level column formula:
=COUNT(ANCESTORS()) + 1
Project – Task Group column formula:
=IF(Level@row = 3, INDEX(ANCESTORS([Task Name]@row), 1) + ” – ” + PARENT([Task Name]@row), IF(Level@row = 4, INDEX(ANCESTORS([Task Name]@row), 1) + ” – ” + INDEX(ANCESTORS([Task Name]@row), 2) + ” – ” + PARENT([Task Name]@row), “”))
0 Comments