At Spreadsheet.com, this year's Spreadsheet Day celebrations were surrounded by a number of new features and enhancements we were excited to launch in October. From our new in-app Template Gallery, to a new data type for rolling up data from related rows, and enhancements to related row lookups, we've been busy.

We're also thrilled to share that Zapier integration is now available in early access for those who want to get started right away before we roll out Zapier support more broadly (details below).

‍

1. New Template Gallery

‍Our new in-app Template Gallery includes live embedded template previews and a Featured Templates section. You’ll also see a new Start from scratch section with templates for starting from a simple Table, Gantt, Kanban, and Form view. We’ve designed these templates as basic starting points for building something new as quickly as possible.

‍

‍2. New data type: Related row rollup

‍We’re thrilled to launch the new Related row rollup data type, allowing you to perform calculations across linked rows from related worksheets and return summarized or aggregated data.

Similar to Related row lookups, Related row rollups look up the values of cells in Related rows, and require at least one Related row column to exist in the worksheet. However, unlike Related row lookups, which return raw data from Related rows, Related row rollups can return calculations, summaries, or aggregates of related data. More details in our October 23rd release notes and our Help Center.

‍

‍3. Related row lookup improvements

‍Now Related row lookups bring all related cell data into the lookup cell, rather than just the first value. For example, in the animation below we create a Related row lookup column to show all of the Photo attachments from each of the Products linked to a Vendor. More details in our October 23rd release notes.

‍

‍4. Zapier integration early access

‍Looking to use Zapier to connect Spreadsheet.com to more of the other apps you use? Zapier integration for Spreadsheet.com is now in early access, allowing you to quickly and easily connect your Spreadsheet.com workbooks to over 4,000 other apps and websites.

We’ll be rolling out full access soon. Meanwhile, we’re inviting anyone who wants early Zapier access to contact us at support@spreadsheet.com for steps to enable it.

‍‍

‍Spreadsheet.com Commercial Launch

‍In a few weeks we'll be activating our paid plans and moving your workspace to a 30 day trial of our Premium plan. You can read more about our pricing plans here. Don't worry, if you choose not to subscribe to a paid plan beyond the 30 day trial period, your workspace will be automatically moved to our Free plan. You won't lose access to any of your data.

Stay tuned for more details in the coming weeks and please contact us at support@spreadsheet.com if you have any questions about this transition.

‍

‍More updates

‍As usual, whenever we release updates to the product we share more details of new features, enhancements, and fixes in the What’s New? section of the Spreadsheet.com Community.  

• Product Updates - October 30, 2021
• Product Updates - October 23, 2021
• Product Updates - October 2, 2021
• Product Updates - September 26, 2021
• Product Updates - September 18, 2021
  ‍

‍What's next?

A few features we're busy working on now:

• Conditional formatting
  Conditional formatting allows you to define rules to format rows and columns using specific font styles, colors, and cell backgrounds based on the data in your worksheet. For example, in a Tasks sheet, you might want to highlight rows that are overdue, or in a Budget sheet you might want to color-code a column of values based on a specific cost range.
  ‍
  
• Named ranges
  We're adding full support for defining and editing named ranges, as in traditional spreadsheets. Today named ranges can be imported as part of existing spreadsheets, and referenced in formulas, but cannot yet be defined and edited within Spreadsheet.com.
  ‍
  
• Select and Multiselect enhancements
  We're adding the ability for options in Select and Multiselect data types to be defined from a named range or a manually specified range of cells, similar to how dropdowns are created in traditional spreadsheets with data validation. This will also work on import and export of Excel files.
  ‍
  
• Print
  Worksheet print capabilities are in progress. This has been a more popular feature request than we expected, and we're excited to be rolling out V1 of Print capabilities soon.
  ‍
  
• Charts
  We're working on initial support for floating Charts in worksheets, similar to traditional spreadsheets. This is also a prerequisite for Dashboards. Combined with Reports, this will form a trio of features that will enable a whole new level of work management in Spreadsheet.com.
  ‍

Stay tuned for more updates coming soon ...