2021: ✅  Done — year in review
Apr 25, 2022

Grouping has arrived + 11 new Templates

Matt Robinson
co-founder & CEO

We’re thrilled to announce the launch of Grouping in Spreadsheet.com, a popular and long awaited feature request allowing you to organize groups of rows with matching column values into collapsable, nested groups.

We also enhanced the positioning of rows inserted from Form submissions, and added 11 new templates to the Spreadsheet.com Template Gallery for use cases ranging from M&A to wedding planning.

Let's take a look!

Grouping

Grouping allows you to display a worksheet’s rows grouped together based on unique values in one or more columns. Like Sorts and Filters, Groupings can be added to any Sheet view using the new Group toolbar button.

Grouping in Spreadsheet.com

Spreadsheet.com supports any number of groupings, allowing you to create views with as many levels of subgroups as you need.

Each column can have its own summary option at each level of the grouping, which is shown in that group’s header. These summaries contain aggregate data like sums, counts, averages, or minimum and maximum values based on the data contained in the group. Each column can have a different aggregation function applied to it.

Grouping Summary Calculations in Spreadsheet.com

Grouping also works in conjunction with table header regions and Gantt timeline views. In addition, rows can be resized within groups just like they can in non-grouped views.

Gantt View with Grouping in Spreadsheet.com

NOTE: When creating groups in a worksheet with row hierarchies, only the parent rows will be grouped according to the grouping rule. All child rows will be placed in the same group as their parent row.

For more information on Grouping in Spreadsheet.com, see Grouping Rows.

You can also check out grouping in action in many of the templates in our Template Gallery.


Enhancements

New Templates

We published 11 new templates to the Template Gallery for business use cases such as M&A and employee timesheets, and personal use cases such as gardening, trip planning, and wedding planning.

For example, the M&A Deal Pipeline template serves as a starting point for your own custom deal flow CRM for M&A allowing you to evaluate targets systematically, manage relationships, report on progress, and create a standardized environment to assess and move more deals forward.

M&A Deal Pipeline Template

Other newly published templates include:

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 new in Sheet Talk?

In our 🌎  Earth Day 2022 blog post, we shared an Earth Day Workbook for calculating your personal “Save the Earth” score and exploring global per capita energy usage.

We also kicked off ⚾️  baseball season with our Visualizing Baseball’s Modern Era with Charts blog post, including a tour of MLB Modern Era Statistics from 1946 to 2021 with charts, and a printable Baseball Scorecard template for you to try your hand at.

What's next?

A few features we're busy working on now:

Stay tuned for more updates coming soon ...