We’re thrilled to announce the launch of Dashboards in Spreadshee​​t​​​​.​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.

Dashboards

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
  ‍

Explore what you can do with Dashboards

Check out our new Guide Using a CRM Dashboard to Manage a Sales Pipeline to learn how Dashboards can be used to visually communicate important data with your team and complement a traditional CRM workbook.
‍

Learn more about Dashboards

• Introduction to Dashboards – Learn more about how and when you can use Dashboards
• Creating a New Dashboard – Learn how to create and configure new Dashboards
• 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.

‍

What's next?

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

‍