Primary expandable column values on report
Hi community,
i have a sheet with some values in the primary column called Month. They are expandable but when I create a report for this sheet the rows underneath e.g. April are of course blank. Is there a way how i can create a report and filter on those items belonging to e.g. April? See print screen of the sheet.
Thanks
Judith
Answers
-
Reports evaluate a sheet on a row-by-row basis. This means that the child rows in your source sheet would need to match your Filter criteria in order to display in the Report, but since the Parent "month" isn't in the cells below, it won't be seen in the Report.
What you can do is set up a "helper column" in the main source sheet with a column formula to bring in that value to the child rows. The formula would be:
=PARENT(Month@row)
Here's another Community post that contains screen capture examples of this solution.
Cheers!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives