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
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!