We’re thrilled to announce the launch of Dashboards in Spreadsheet.com.
We also rolled out ability to create a new workbook from publicly shared Views, improved the speed of bulk OpenAI formula requests, and enabled Zoom level in publicly shared and embedded workbooks.
Let’s take a look.
Now with Dashboards you can quickly build and share an overview of projects and initiatives with data from any number of workbooks and views.
Like Workbooks and Reports, Dashboards are a new document type that can be created in any workspace and folder from the + New dialog:
The first step in creating a Dashboard is to select the source worksheets you want to pull data from:
Once your source worksheets are selected, the next step is to add widgets that display all the information you want to visualize.
Dashboards are made up of a number of configurable widgets that range from rich text to embedded views, numbers, images, videos, and more:
Because Dashboards are modular, customizable, and can include information from any number of Spreadsheet.com workbooks, there are literally endless ways to use them. Some common ways you might use Dashboards are…
Team Collaboration : Use Dashboards as a central place to display information for teams whose work is spread across many different workbooks
Data Access Control: Use Dashboards to share important information with external consultants or clients without having to expose sensitive internal information
Widget Types 1 – Learn more about widgets, the modular pieces that make up each Dashboard
Sharing Dashboards – Learn how to share your Dashboards with other Spreadsheet.com users or with the public
Copy View capability in publicly shared Views
Following the release of public View sharing and embedding, we’ve added the ability to allow users to Copy View. This creates a new workbook from the shared view, with only the data present in that view.
This ability is enabled by default in shared Views and can be disabled in the public View sharing and embedding dialog.
Faster OPENAI_COMPLETE function calls
For those using our OpenAI integration function, OPENAI_COMPLETE, now the performance of updating column formulas and when dragging down to autofill is up to 10x faster.
Zoom now works in publicly shared workbooks
Now when a workbook or template is shared publicly or embedded, Zoom level is enabled.
A few features we're busy working on now:
Button Data Type Ability to create buttons in cells that open a URL or trigger an automation to create a row or send an email, Slack notification, etc. about the row in context.
Row Movement Ability to drag and drop rows to reposition them in Sheet and Gantt views. This includes the ability to move parent rows in a hierarchy and have all child rows move with them.
Drag & Drop Cell and Range Movement Similar to traditional spreadsheets, we’re adding the ability to drag and drop individual cells and ranges to move them in the grid.
Notifications An in-app notifications list updated in real time showing each user all of the row assignments, @mentions, alerts, and reminders meant for them.
Mobile Apps V1 of the Spreadsheet.com mobile app for iOS and Android.
Stay tuned for these and more updates coming soon ...