SmartSheet not populating cells into report
I have a SmartSheet that I have set up to populate cells into a report for others to view. I am able to see all of the cells in the report, but when I sent it over to my colleagues, they are noting that the column headers are there, but the cells are all blank. Please help!
Answers
-
Hi, @ksato
Unless you are sharing via a published link, the colleagues that you are sharing the report to will also need to be shared to any underlying sheets that feed the report.
More information can be found here: https://help.smartsheet.com/articles/520104-share-sheets-reports-dashboards
-
Thank you! I figured this out and ended up sharing the main sheet with the group. However; I am using the "group" function, and for some reason, the actual groups are not showing up on the report. Is there a way to display the actual group name on the report? Please help!
-
Hi @ksato
Do you mean that you are using Hierarchy on the Sheet, so there are top-level Parent rows and indented Children rows below them? (See: Hierarchy: Indent or Outdent Rows)
If so, Reports evaluate the underlying sheet on a row-by-row basis without reading the hierarchies. You would want to bring in the Parent name into each Child Row so that you can use this in your Report to Group by; here's another Community Post that explains how to do this.
Cheers!
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- I thought combining the four different sheets into one report would eliminate the need to share all four separately. However, I was just informed that they're unable to see the context of the report, …
- Hello, I created a smartsheet with a form, and when I saved this smartsheet as a new file so I could keep the template, I can't get the form to show on the left hand side of the screen for easy access…
- I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is…
