How? Column Formula to Pull Level 1 Parent Task Name

Hi Smartsheet Community,
Please see image of setup! I am trying to create a column formula for the column 'TEST' that pulls the name of the Level 1 parent task for each row. Essentially, I want every cell in the 'TEST' column to display the name of its Level 1 parent, such as "baseline estimate" or "estimate R1," depending on which is their Level 1 parent task. I would like to be able to differentiate between estimate iterations for every child task within that section.
Is there a way to set up this formula in Smartsheet so that it automatically pulls the top-level parent task name for each row?
Thanks in advance for your help!
Answers
-
Hi @gabbim,
I believe that the following formula is what you are looking for.
=INDEX(ANCESTORS([Task Description]@row), 1)
The one at the end determines which level you would like displayed.Hope this helps!
Thanks,
John
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 203 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!