A column using the ANCESTORS, is it possible to get it to display "Top Level" of a hierarchy?

REmley

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?

Carson Penticuff

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), " > "))

Carson Penticuff

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), " > "))

REmley

Thank you for the help!