Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.


J. Craig Williams
J. Craig Williams ✭✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

In the Formula Help template (v2.0, line 109), there is an example of using JOIN with ANCESTORS




The formula is:


=JOIN(ANCESTORS([Value 1]105), ", ")


The result is:


Hierarchy Formulas, Parent Row, Child Level 1


but row 91 (the 'oldest' ancestor) appears to be blank because it is grey text on a grey background.


Not nice as it took me a minute or two to figure out why that result was being returned.


Please don't make examples that are hard to follow.








This discussion has been closed.