Product updates: Duplicate and hide worksheets, Multi-column insert, 1-way and 2-way relationships, and more
co-founder & CEO
Over the past month we launched a handful of popularly requested features along with a number of enhancements and new capabilities based on feedback from Spreadsheet.com users. Read on for a summary.
We’re happy to share the release of Duplicate worksheet capabilities, one of the most popular feature requests we’ve heard since opening up access to the product. As with traditional spreadsheets, all of your styling, formatting, and formulas are maintained as-is. All data type configuration information and views are also copied. In addition, attachments and relationships are maintained and work as expected in the new worksheet. Read more in our September 6th release notes.
As with traditional spreadsheets, Spreadsheet.com now supports the ability to hide worksheets. Imported workbooks with hidden worksheets now work as expected, with hidden worksheets remaining so by default. Only users with Owner and Manager access to a workbook can hide and unhide worksheets.
You can now insert multiple columns at once. Select more than one column, right click, and choose one of the Insert X columns right or left menu options, as shown below.
Gantt view sub-day duration support (part 1)
Task bars now clamp to the nearest hour when they are resized or moved in Gantt views.
Current date & time in automations
When updating Date and Date & Time values in automations you can now make use of the new Current Date and Current Date & Time tokens to define a relative value, as shown in the animation below. This makes it easy to change dates and times based on when another update or creation action occurs.
1-way and 2-way relationships
Spreadsheet.com now allows you to specify whether relationships are 1-way or 2-way (default). With 1-way related row columns, a corresponding column does not get created in the target worksheet. This was a prerequisite for launching Duplicate worksheet functionality. Read more about 1-way and 2-way relationships in our August 28th release notes.
Fixes and enhancements
We also released over 50 more fixes and enhancements, including:
Support for additional Date formats
Formula bar no longer read-only for users with Editor access.
Related row search box now automatically in focus so you can start typing to find matching rows immediately.
Sharing by link We’re expanding the set of sharing options for folders and workbooks allowing them to be shared using a preconfigured link. Options include sharing to only a specific set of users, any users who belong to a specific set of named domains, or anyone with the link.
Column Formula data type enhancements Ability to define an output data type and data type-specific settings for column formula columns. This also includes the ability to reference worksheet table columns by name in formulas.
Related row type-ahead autosuggest and other enhancements We’re improving the related row cell editing experience to allow type-ahead autosuggest and selection with the keyboard, similar to the Select and Multiselect cell editing experience. We’re also working on some improvements to the related row data type configuration experience.
Related row rollup (new data type) We’re working on a new column-level data type for rolling up data from related rows. This will allow you to choose from a set of aggregation functions and formatting options when defining how rollups work.
Zapier integration We’re in the process of being added to the Zapier app directory, which will allow you to create zaps that connect Spreadsheet.com worksheets with over 4,000 other apps and sites.
Workbook loading speed improvements Several optimizations are underway that we expect will improve the speed of workbook loading significantly.
Named ranges Full support for defining and editing names 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.
Duplicate columns Ability to copy columns within and across worksheets and workbooks, including column-level data type settings.