Jul 17, 2022

Product Updates: Calendar view launch, 23 new templates, performance improvements, and best practice resources

Matt Robinson
co-founder & CEO
What’s new in Spreadsheet.com?

Calendar View has been updated with four new features:

  1. A mini-calendar sidebar showing multiple months of events
  2. Drag & drop event assignment
  3. Conditional formatting for custom event coloring
  4. iCal link sharing for integrating Calendar views with other apps

We also rolled out a complete revision to cross-sheet formula updates resulting in up to 100x faster performance, and we added 23 new templates to the Spreadsheet.com Template Gallery for use cases ranging from sales pipeline management to venture capital deal flow.

In addition, we added two new sections to the Spreadsheet.com website for industry and product-related best practices: Work Management Resources and Spreadsheet.com Guides.

Let’s take a look!

Calendar View now out of Beta with new features

We’ve dropped the Beta tag from Calendar View after completing a set of four new core features.

1. Calendar Sidebar

You’ll see a new sidebar in Calendar views with a scrollable mini-calendar that shows several months of events at a time. This is a great way to see a 10,000 foot view of your work over a longer period of time alongside the finer grained details of a Month, Week, or Day view.

Spreadsheet.com Calendar View with Mini-calendar Sidebar

Colored dots under each day indicate how many tasks or events are currently scheduled for that day to give you a quick visual indicator of your workload.

2. Drag and drop event assignment

The Events tab in the new sidebar allows you to see a list of all events in your worksheet and filter by All Events, Events with Date, or Events without Date. Dragging any event into the calendar assigns, or re-assigns, date values to that event.

Spreadsheet.com Calendar View with Drag & Drop Event Assignment

This is a great way to quickly schedule a set of tasks or events that have not been scheduled yet.

3. Conditional formatting for custom event coloring

In addition to setting a custom color for all events and choosing a Select column to determine the color of events, you can now define conditional formatting rules to determine how events are colored in Calendar views.

Spreadsheet.com Calendar View with Custom Event Coloring

This is a great way to build out Calendar views for specific people and teams with color-coded work most relevant to them.

NOTE: Conditional formatting for calendar event coloring is available on Standard and Premium plans.

4. iCal link sharing for 3rd party calendar integration

The new Share view toolbar button enables a dynamic link to an iCal-based view of your Calendar View data that can be used to sync events with 3rd party calendar applications such as Google Calendar.

Spreadsheet.com Calendar View iCal link sharing

For more information on Calendar views in Spreadsheet.com, see Calendar Views.

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

Cross-sheet formula performance improvements

After months of work by our formula engine team, we’re thrilled to have launched a fundamental rewrite of cross-sheet formula computations and updates on both the server and client (i.e. browser), resulting in up to 100x performance improvements for cross-sheet formula updates.

This is a big step toward complex financial and numerical modeling support in Spreadsheet.com. Stay tuned for worksheet Zoom and array spillover support to round out this feature set.

Spreadsheet.com Guides

We recently launched Spreadsheet.com Guides, a new destination for learning how to use Spreadsheet.com features to build solutions for a wide variety of use cases such as project management, CRM, content marketing, product development, hiring, construction, and more.

Spreadsheet.com Guides

For example, in our Managing a Hiring Pipeline with Spreadsheet.com guide, you’ll learn how to build a fully functional applicant tracking and interview management system using form views, related rows, automations, and more.

Other guides you may enjoy:

Work Management Resources

We also launched Work Management Resources for learning about best practices, tools, and techniques for effective project management, sales and CRM, hybrid and remote work, and more.

Spreadsheet.com Work Management Resources

For example, in our 5 Phases of Project Management article, you’ll learn about the phases of project management defined by the Project Management Institute (PMI), a global not-for-profit association that aims to help individuals and organizations work smarter. PMI has been around for more than half a century, and its project management principles have stood the test of time.

Other articles you may enjoy:

New Templates

We published 23 new templates in the Spreadsheet.com Template Gallery for use cases ranging from sales pipeline management to conference planning, real estate CRM, project roadmap with sprints, venture capital deal flow, and more.

For example, the Project Roadmap with Sprints template comes with built-in Calendar, Gantt, and Kanban views, and row grouping, so it’s easy to automatically group your project tasks into their respective sprints and visualize everything in interactive calendars, timelines, and work boards.

Spreadsheet.com Project Roadmap with Sprints Template

The Sales Pipeline template provides an easy way to track and analyze your sales pipeline with deals, companies, contracts, and interactions, linking all of your worksheets together with Related rows to turn your workbook into a sales database.

Spreadsheet.com Sales Pipeline Template

The Conference Planner template can be used to organize your next conference, speaker series, or event. Use the Events worksheet to list events and log details like location, time, and a description, and a built-in Calendar view to visually manage schedules. Use Related rows to link the Events worksheet with the Speakers worksheet and create a roster of speakers and presenters.

Spreadsheet.com Conference Planner Template

Other newly published templates include:

What's next?

A few features we're busy working on now:

Stay tuned for these and more updates coming soon ...

More blog posts ...