A column using the ANCESTORS, is it possible to get it to display "Top Level" of a hierarchy?
![REmley](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I was wondering if it possible for this to work? I want the Parent Details to read "Top Level" if the Task Name is at the top level of the hierarchy.
This is the formula I have come up with:
=IF(ISBLANK([Parent Details]@row), "TOP LEVEL", JOIN(ANCESTORS([Task Name]@row), " > "))
This is reading back circular reference because I am referencing the "Parent Details" column. Is what I am asking possible or am I just not using the right functions here?
Best Answer
-
I think I understand what you are looking to do, but please correct me if I am wrong.
=IF(COUNT(ANCESTORS([Task Name]@row)) = 0, "TOP LEVEL", JOIN(ANCESTORS([Task Name]@row), " > "))
Answers
-
I think I understand what you are looking to do, but please correct me if I am wrong.
=IF(COUNT(ANCESTORS([Task Name]@row)) = 0, "TOP LEVEL", JOIN(ANCESTORS([Task Name]@row), " > "))
-
Thank you for the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!