Report showing particular sheet Parent+Children rows
I want to populate a Report with a particular Parent row (level 6 indent) + it's children.
The sheet is a very large schedule running to more than 1000 rows and with 7 levels of indent and counting.
This is something I need to do on a regular basis - is there some hack to achieving this?!
Thanks,
Robert
Answers
-
You could create a helper column for each incident level and use this formula in each level, adjusting it slightly.
This above would be for level 2.
Level 3 =IF(COUNT(ANCESTORS()) = 2, 3, [Incident Level]@row)
and so on.
This assumes you have a top level row and every row under that is indented.
I use the Incident Level column to test the accuracy of my formula. You can have an incident level column with the formula =COUNT(ANCESTORS()) or you can adjust my above formula to say:
=IF(COUNT(ANCESTORS()) = 1, 2, COUNT(ANCESTORS()))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!