JOIN(ANCESTORS()) example

J. Craig Williams

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

 

 https://app.smartsheet.com/b/launch?lx=ZRqX2Q4TSzFgNI_3hZWDkl2F3tjZfBYMX....

 

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.

Thanks.

Craig

 

 

 

Tyler Marquardt

Craig, 

Thanks for the feedback. I'll make the change so the formula is easier to follow. 

Thanks!

Tyler