A column using the ANCESTORS, is it possible to get it to display "Top Level" of a hierarchy?
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?
Help Article Resources
Check out the Formula Handbook template!