Client dashboards

Hi, I'm currently using airtable but thinking of moving to smartsheet.

My specific need is to take the table data (which my team updates 24/7), format it into simple dashboards, and provide those dashboards to clients particularly via mobile device.

With airtable I can display data via mobile devices but not in a dashboard view and not with adequate permission control.

Essential:

Permission control driving the data appearing in the dashboard, to allow my clients to see their own data and only their own data

I haven't been able to work out whether smartsheet is right for this need - any advice?

Find more posts tagged with

Sharing and Collaboration

Mobile

Reports

Comments

Mike Wilday

There are ways of publishing dashboards so that clients can view them... publicly on the web, which wouldn't give them access to the granular data on the sheets themselves. I think what you're wanting to do is possible. How is the initial data generated? By you, by your clients?

Andrée Starå

Hi,

There are several ways to do what you want.

Depending on how sensitive the information is it could be behind a password in another third-party solution.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike L.

I'd like to piggyback on this and hear more about password protected third party solutions. I have a small workspace with dashboards that allow you to drill through categories to see active company projects. The benefit is to someone in the field who may not actively participate on all projects but can quickly get top level information when meeting with potential clients. Also available is an attached pdf executive summary for each project. So a public site could work if password protected.

Andrée Starå

Hi Mike,

I don't know why I didn't think of this before, but you could have specific dashboards for each client with their report(s), and they wouldn't need to be shared to the underlying sheets.

Would that work for you?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Shaine Greenwood

Hi all—

To echo what other community members have said: dashboards for your clients and stakeholders is the best way to accomplish this.

You can add information (including data from other applications with the web content widget) to your dashboard and share it only with your client without having to share the underlying source sheets and reports to them.

More information on dashboards can be found in our help center: https://help.smartsheet.com/learning-track/smartsheet-advanced/dashboards-and-portals

You might also want to speak with our Sales team to discuss your needs and work with him on how they can be accomplished: https://www.smartsheet.com/contact-us-sales

Mike Wilday

Click on the world icon in the dashboard to publish a view-only version of the dashboard that you can share with your clients which provides no access to underlying sheets.

Sign in to join the conversation!

Quick Links

Trending discussions

I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…