Product updates: 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
Form Submission Improvements: We enhanced the Form submission process so that newly created rows always get inserted after the previous Form-created row.
Printing Grouped Views: We’ve added support for printing grouped views, and exporting grouped views to PDF.
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:
M&A Stakeholder Communication Plan (M&A) Manage M&A communication tasks and announcements with attachments, status tracking, stakeholders, deadlines, and clear ownership.
M&A Issues Report (M&A) Track owners, priorities, documents, and status of issues during an M&A process.
M&A File Requests with Form (M&A) Manage the process of document collection during a merger or acquisition using with a pre-built Form and Kanban board.
M&A Financial Synergy Valuation Template (M&A) Calculate and analyze the combined valuation of an M&A synergy with this template based on the Corporate Finance Institute's Financial Synergy Valuation Worksheet.
M&A Synergy Analysis (M&A) Project the combined revenue, COGS, SG&A, pre-tax revenue, and net income of a deal's M&A synergy. Based on Wall Street Prep's M&A Synergies Worksheet.
Weekly Multi-Employee Timesheet with Overtime (HR) Record daily regular and overtime hours worked, as well as sick days and vacation days. Enter hourly pay rates to automatically calculate weekly pay for each employee alongside the total weekly hours worked.
Gardening (Personal) Plan and manage any gardening project from seed inventory to depth of planting, sun exposure, planting layout and locations, and watering schedule.
Trip Planner (Personal) Plan, manage, and collaborate with fellow travelers every stage of a trip from budgeting and booking flights to making a checklist of last-minute prep items.
Wedding Planner (Personal) Plan and manage every detail of a wedding from a guest list to a built-in RSVP form and responses, seating plans, budget, vendors, and more.
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.
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.
Calendar View A new worksheet View type showing a daily/weekly/monthly calendar to manage rows visually based on the value of a Date or Date & time column.
Gantt View and Project Management Improvements We're serious about project management and have a whole set of Gantt view and project management improvements coming soon.
Cross-sheet Formula Improvements We’re redesigning the way cross-sheet formulas are computed, optimizing for both reliability and significant performance improvements.
Row Movement We're adding the ability to drag and drop rows to reposition them in Sheet and Gantt views. This includes the ability to move parent rows in a hierarchy and have all child rows move with them.
Drag & Drop Cell and Range Movement Similar to traditional spreadsheets, we're adding the ability to drag and drop individual cells and ranges to move them in the grid.
Trash A trash area (i.e. recycle bin) will allow you to recover deleted workbooks.
API V1 We're working on publishing an initial version of our REST API that can be used to programmatically interact with Spreadsheet.com workbooks.
