Filter by Parent Row with Children and Grandchildren
Hello! I recently created a sheet to track all of our projects (parent row) with some high level milestones (child row). I created a helper column so that I could filter just by the parent row of each project. In the helper column, I used this formula: =IF(COUNT(CHILDREN([Feature Request]@row)) <> 0, [Feature Request]@row, PARENT([Feature Request]@row)).
This worked for a while, but leadership has recently asked to add an additional indent or two, so now I have grandchildren rows. Is there a way that I can keep just the top parent row name in my helper column? I'm not sure what to edit in my formula to make it work.
Any help would be greatly appreciated! Thank you!
Example: I'd like everything in the column named "Project" to just say Project 1 or Project 2 in the screen shot below.
Best Answer
-
Project formula:
=IFERROR(INDEX(ANCESTORS([Feature Request]@row), 1), [Feature Request]@row)
Answers
-
Project formula:
=IFERROR(INDEX(ANCESTORS([Feature Request]@row), 1), [Feature Request]@row)
-
@Mike TV Thank you so much for the help!!! This is exactly what I needed!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!