Blank Report
I shared a report with a customer. When the customer opens the report it is blank. It doesnt show any of the data?
I tried sending a link to the report as well. Still nothing in the report.
The customer setup a username and password.
Im obviously missing something. Any ideas as to why the data doesnt show up in the report?
Does the customer have to have permission to view the actual sheets?
Thanks for your help!
SGF
Comments
-
Hi Steve,
Are they shared to the sheet(s)?
They have to be shared to the sheet(s) to be able to see anything in the report it, or you have to publish it.
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andree,
If i share the sheets with them, they will have access to all of the info in the sheets? I dont necessarily want them to be able to see off of the info on the sheets. I created the report for them to be able to see only certain info from the sheets.
How do i only make certain information available to them? as opposed to all of the information?
Thanks,
SGf
-
That's correct! You'd want to publish the report instead because then they don't need to be shared to the sheet. They will see the same information in the report as the person who published it.
Try publishing it and then open an incognito browser window or similar and view it there and if you see the same thing, then it's working.
Ok?
Hope that helps!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
More info: https://help.smartsheet.com/articles/522078-publishing-smartsheet-items#publishreports
Shared report is appearing blank
Reports will appear as blank, or appear to have less information, when someone else looks at the report and they're not shared to the underlying sheets that the report is looking at. A report doesn't give access to sheets that haven't already been shared to someone (For more information see Share Sheets, Reports, and Dashboards).
If they don't need to edit data on the report, you can publish the report to display it in a read-only format. When published, the underlying sheets don't need to be shared for the data to be visible on the published version (See Publish a Report).
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Ah! Yes!
Perfect. Exactly what i was looking for!
Thanks,
SGF
-
Excellent!
happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Had to look this up and your advice just helped me.
Thanks Andree -
Excellent!
Happy to help!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
The problem with this is I only want users (free license) to be able to update the sheet via a shared report. Sharing the entire sheet as Editor, gives them way too much control over the underlying sheet.
-
You could publish the sheet instead.
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I'm having the same issue as @Darren Longnecker. When I publish my sheet/report it makes it view only. Is there another work around for this?
-
Really helped. I was trying to figure this out for a while. Thanks, @Andrée Starå
-
I have a question along the same lines and have figured out the publish option, but I have another group of people that need access to edit the information in my report (not all info in the underlying sheets). Is there a solution for this scenario?
-
@Andrée Starå any solution for users who you need to be able to edit the report but can't have access to the underlying sheet
-
Excellent! Glad to hear it was helpful!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K 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