Is it possible to attribute all levels of child rows to the same parent hierarchy?

I have a Project Plan with multiple levels of hierarchy, but I'd like to have a column formula that would tie everything to its relevant parent. Essentially what I am looking for is a formula for the Project Column below where even the grandchild or great-grandchild tasks associate to the highest level parent w/in the hierarchy.

Why do I want this and why can't I use Filters?

I have multiple projects being tracked in a single file and I'd like to be able to filter down to a specific project (i.e. Project = Project 1). The 'include parent rows' option in the filter panel works if I had something specific to filter on, but once I drop down past level 2, then the PARENT function breaks away from the Project Name.

Please help Smartsheet Community, you're my only hope.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!