Formula to show only certain parent row names


Hello! I have figured out how to specify if a row is a parent/child row (we call them Project/Tasks).

I am trying to find a formula that will automatically pull from a specific parent hierarchy. In this case, it will always be the parents that have only been indented once (rows 22, 31, and 38). Rows 32 through 37 show what is currently a manual process, and row 23 through 30 is my attempt so far to automate this.

I can manually tell each row which parent row to pull from (=[Task Name]$22), but this is still very time consuming and needs daily maintenance when new rows are added.

=PARENT([Task Name]@row) only pulls the immediate parent name. Is there a way to formulate which parent I want it to pull a name from?



Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!