Sep 8, 2021

Product updates: Duplicate and hide worksheets, Multi-column insert, 1-way and 2-way relationships, and more

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

Duplicate worksheets

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.

Duplicating worksheets in Spreadsheet.com

Hidden worksheets

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.

Hiding worksheets in Spreasheet.com

Multi-column insert

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.

Multi-column insert in Spreadsheet.com

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.

Gantt view sub-day duration support in Spreadsheet.com

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.

Current date & time in Spreadsheet.com automations

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.

1-way and 2-way relationships in Spreadsheet.com
Fixes and enhancements

We also released over 50 more fixes and enhancements, including:

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.  

What's next?

A few features we're busy working on now:

… and more. Stay tuned!

More blog posts ...