How To Reference Top Parent For Each Row


I'm trying to implement a formula that will reference the name of the rows Top/First Parent for each row. I have reviewed other threads on this and have not seen a definitive solution (or just one I could get to work). Ideally looking for something that could then be used as a column formula.

Our sheet is organized into 7 stages and ideally each row under each of these stages would reference the Top/First Parent task name independent of how many levels of hierarchy there are within the stage.

Screen shot of desired future state.

Any help is appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!