Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions