Including Parents in Report
I'm creating a report and filtering by the value in a particular column. However, I would like to see the parent rows as well. In the original sheet, I can create a filter and check the box that says "include parent rows". However, in the report, I don't have that option when selecting a filter. How can including the parent rows be accomplished in the report?
Answers
-
Hi @BSADK
Reports evaluate a sheet on a row-by-row basis, without registering the Hierarchy. This means that the parent rows in your source sheet would need to match your Filter criteria in order to display in the Report.
It's likely we could create a "helper" column with a formula to auto-populate data in your parent rows in the sheet, so that you can then use this in your Report filter. Here's another Community post with an example: Parent/grand-parent rows in reports
If you need help with this, please post screen captures of your sheet and report, but block out sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives