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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!