Smarter Tables
Cost-effective viewing and editing of Smartsheet data
Smarter Tables is a portal that allows administrators to provide controlled access to Smartsheet sheets and reports without sharing the underlying assets directly. It is a cost-effective alternative to Smartsheet’s Premium App, Dynamic View, enabling users to view and edit allocated data without needing a paid Smartsheet subscription.
Smartsheet’s User Subscription Model (USM) means companies can face substantial increases in subscription costs for users who simply need to update data. While Dynamic View provides a way to grant controlled data access without sharing entire sheets, its high cost makes it an expensive solution. Smarter Tables offers a more affordable alternative, allowing administrators to control access to specific rows and columns while enabling users to edit data without requiring their own paid Smartsheet subscription.
Check out our Smarter Tables demo video
Core Benefits
Cost-effective access
Allow users to view and edit Smartsheet data without purchasing a paid Smartsheet subscription for each user who needs to update information.
Granular access control
Determine which rows and columns individual users can see and edit, without exposing the entire underlying sheet or report.
Significant savings
Achieve the required functionality at up to a tenth of the price of Dynamic View.
Flexible authentication
Let users access Smarter Tables using Google or Microsoft credentials, as well as Smartsheet credentials.
Faster editing
Update data directly within the grid using inline editing, without having to open a side panel for every change.
Flexible Design
Example use cases
Project managers need to see and update just their own data
Set up a single view with a table widget showing the required columns. Set the view to show Current User data only and make the right columns editable. Other PM rows are not visible and no-one needs to be shared to underlying data.
You have a large amount of data spread across multiple Smartsheet sheets
We could use a Smartsheet report to collate the data into one place then sync this report with a SQL database on our server. Smarter Dashboards will read the data from SQL, not directly from Smartsheet, so it’s much quicker to load.
You need to show the same data set to different stakeholders with their own needs
Set up a view for each user type to reflect their individual requirements. Allocate views to user groups to provide the appropriate insights to each team.
What do our clients think about Smarter Dashboards?
Frequently Asked Questions
-
Yes, but… Smartsheet’s dashboards are great for basic use but are static. Smarter Dashboards provides a much more dynamic experience with live filtering and inline editing
-
Just head over to www.smarterdashboards.net. If you have a Smartsheet account, you can just sign in with that. Then simply point Smarter Dashboards to the sheets or reports you want to visualise, and you’re away.
-
Absolutely. You can have a 14 day trial with no obligation whatsoever. If you need longer to properly evaluate the product, or to get the right people in the room to give you the thumbs up, talk to us and we can work something out.
-
You certainly can. We offer an hour of free consultancy to help you get started. There is also a Getting Started video that leads you through the creation of a standard dashboard view. If you would like more assistance, we can offer an expert consultancy package, where we will analyse your data and set your dashboards up for you in quick order.
-
The dashboard owner (and anyone they make an admin) can add, change and remove views, filters, charts and tables, customise the colour scheme, specify which users can see what, amongst many other aspects.
-
Smarter Dashboards currently integrates with Smartsheet, SQL and Google sheets. Airtable integration is on the product roadmap.
How does Smarter Dashboards make Smartsheet even Smarter?
Smarter Dashboards is so much more dynamic meaning you only need to create one dashboard and everyone can use live filters to change focus. Here’s how Smarter Dashboards could be better for you:
Can I filter my dashboard?
Smarter Dashboards => Yes you can! Live filtering allows for laser focus
Smartsheet => No, you’d need to create new dashboards based on different data sets
Can I view data from other sources?
Smarter Dashboards => Yes! You can currently load data from SQL and Google Sheets. Drop us a line if you need data from other places too.
Smartsheet => not directly, you would need a Premium App such as Data Shuttle.
Do all my users need a Smartsheet licence to edit the data?
Smarter Dashboards => Not necessarily, we can authenticate in a number of ways and use a single token to interact with Smartsheet
Smartsheet => Yes, each user will need at least Editor rights which will need a Smartsheet license.