HELP!!! - Return the Ancestor Containing a Specific Character



Level 1

Level 2

Level 3 * The Cell Contents I Need

Level 4

Level 5

Level 6

I'm in a cell in the same row as Level 6 (for example); and I know that a row in the ancestors contains a "*"; how can I retrieve the value contained in the the row that contains the "*"?

Thanks in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!