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

Jake Gustafson

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.

Paul Newcome

Try this:

=IF(Level@row = 1, [Project/Task]@row, INDEX(ANCESTORS([Project/Task]@row), 1))

Paul Newcome

Try this:

=IF(Level@row = 1, [Project/Task]@row, INDEX(ANCESTORS([Project/Task]@row), 1))

Jake Gustafson

That did it @Paul Newcome. Thanks.

Paul Newcome

Happy to help. 👍️