Calendar View has been updated with four new features:
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!
We’ve dropped the Beta tag from Calendar View after completing a set of four new core features.
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.
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.
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.
This is a great way to quickly schedule a set of tasks or events that have not been scheduled yet.
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.
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.
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.
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.
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.
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.
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:
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.
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:
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.
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.
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.
Other newly published templates include:
A few features we're busy working on now:
Stay tuned for these and more updates coming soon ...
