How To Reference Top Parent For Each Row

Options

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!