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

Options

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.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!