Product Updates: Calendar view launch, 23 new templates, performance improvements, and best practice resources
co-founder & CEO
What’s new in Spreadsheet.com?
Calendar View has been updated with four new features:
A mini-calendar sidebar showing multiple months of events
Drag & drop event assignment
Conditional formatting for custom event coloring
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.
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.
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.
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.
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.
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.
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.
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.
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.
Reports Reports will allow you to easily work with data across a number of worksheets, even in different workbooks, to create consolidated views of projects, tasks, events, deals, milestones, etc., that updates in real time for all stakeholders.
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.
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.
Mobile Apps A dedicated team of developers has been working hard on initial versions of the Spreadsheet.com iOS and Android mobile apps, with pinch zoom, touch gesture support for cells, and several other complex features that most of us take for granted in spreadsheet apps.
API V1 We're also working on publishing an initial version of our REST API that can be used to programmatically interact with Spreadsheet.com workbooks.
Stay tuned for these and more updates coming soon ...