Product updates: Named Ranges, Select from Range, and 6 new Templates
co-founder & CEO
As the year comes to an end, we’re happy to share the release of new features designed for working with ranges of cells in formulas, Select, and Multiselect data types. In addition, we've published new templates for use cases ranging from fundraising to construction project management, budgeting, and more.
With named ranges, you can now assign a name to a contiguous range of cells for easy reference in formulas.
As in traditional spreadsheets, each worksheet can have any number of named ranges defined. In addition, Spreadsheet.com now fully supports named ranges when importing from, and exporting to, Excel.
For more details, see the new Named Ranges article in our Help Center.
Select and Multiselect option enhancements
We also added the ability to define Select and Multiselect options from a Named range or a manually selected Range of cells from any worksheet in the current workbook. Similar to data validation in traditional spreadsheets, this allows you to more easily share and reuse options between columns and ranges of Select and Multiselect cells.
The new Source field in the Select and Multiselect data type dialog provides three different choices for how options are defined, as shown below:
List of options (default): Allows you to manually define a set of options with sort and reorder capabilities.
Range of cells: Allows you to select a range of cells, from any worksheet in the workbook, to use as options.
Named range: Allows you to select any named range in the workbook to use as options.
For more details see our help center articles on the Select and Multiselect data types.
For example, the new Construction Product Plan template is designed to help construction project managers organize tasks, people, and items. This can be used in conjunction with the Construction Budget template to help construction project accountants manage the budget throughout a project.
The new Implementation Plan template is designed for planning, tracking, and managing each stage of a software, process, or other type of implementation project. Gantt and Kanban views help users visualize the progress and status of tasks.
The new Fundraising Due Diligence Checklist template serves as a data room that you can share with your team and investors after signing a term sheet, allowing you to cut as much as a week off of your closing process. This template was adapted from a checklist originally created by Jason Kwon, former GC of YC Continuity, after being involved in "hundreds of financings with nearly every law firm and VC fund in the valley."
Other newly published templates include:
Team Task List (Project Management): A simple place for teams to track and manage tasks for a project, initiative, or other joint effort.
Student Attendance (Education): For teachers to track class attendance with a daily log and summary, along with the attendance record of each student through a month.
College Applications (Education): For students applying to college to keep track of schools, applications, essays, references, and more.
Spreadsheet.com commercial launch
In the first week of January we plan to activate billing plans. At this time your workspace will be automatically moved to a 30 day trial of the Premium plan. You can read more about our pricing plans here. Don't worry, if you choose not to subscribe to a paid plan, your workspace will be moved to the Free plan when your trial period ends. You won't lose access to any of your data. Stay tuned for more details in the coming weeks and please contact us at email@example.com if you have any questions about this transition.More updatesAs 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.
Zapier integration Spreadsheet.com is now in beta in the Zapier app directory, allowing you to create zaps that connect Spreadsheet.com worksheets with over 4000 other apps and sites. Full launch coming soon. Login to your Spreadsheet.com account and visit Personal settings > API keys to create an API key for connecting Spreadsheet.com with Zapier. More details in the new Zapier Integration section of our Help Center.
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.