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
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!