How can I name all descendants after a parent row at a specific level?


I am trying to add a column for a report that will give us an overall view every task of a specific Phase. The Phase Name will sit in a Level 1 child row. I am using a formula of =if(Level=1,"",parent([Task Name]@row)). This is great if I only have one level of children. If I have more, I get the parent row of the level 3 or 4 (etc) children.

Is there a way to only have the Level 1 phase name returned for all descendents? I tried another IF phrase of only looking at Level 2 but it leaves children 3 and above blank as well as a few other things and haven't been able to accomplish what I am hoping to do.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!