Blank Report

steve50951 · 07/10/19

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

Andrée Starå · 07/10/19

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

steve50951 · 07/10/19

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

Andrée Starå · 07/10/19

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!

Andrée Starå · 07/10/19

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).

steve50951 · 07/10/19

Ah! Yes!

Perfect. Exactly what i was looking for!

Thanks,

SGF

Andrée Starå · 07/10/19

Excellent!

happy to help!

SYSPK · 10/16/19

Had to look this up and your advice just helped me.

Thanks Andree

Andrée Starå · 10/16/19

Excellent!

Happy to help!

Darren Longnecker · 12/15/20

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.

Andrée Starå · 01/16/21

Hi @Darren Longnecker

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!

Ryan Neyland · 07/20/21

https://community.smartsheet.com/discussion/comment/271919#Comment_271919

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?

SIS · 02/18/22

Really helped. I was trying to figure this out for a while. Thanks, @Andrée Starå

StefanieM · 05/20/22

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?

CDS · 10/05/22

@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

Andrée Starå · 10/05/22

@SIS

Excellent! Glad to hear it was helpful!

Smartsheet Basics

Smartsheet Basics

Blank Report

Comments

Shared report is appearing blank

Quick Links

Categories

Trending in Smartsheet Basics

Conversations in Sheet vs Report (for the Sheet)

Conditional Formatting

Displaying Multiple Project Phases in One Gantt Chart Line