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 help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives