Formula to return the level one task name of a subtask


I'm having trouble figuring out how to create a formula that always returns the top-level (level 1) task of the subtask underneath. I've been able to return a parent, which works for level 2, but once I get to level 3, it'll return the parent as level 2. I want level 1 for this new column.

Line 406 is a good example, as it's returning the level 2 parent task name. My new column, I'd want to return "Overrides" or the task in row 401, which is the top task within the hierarchy.

Thanks in advance for some help here!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!