Product updates: Conditional formatting and new templates
Matt Robinson
co-founder & CEO
New feature: Conditional formatting
We’re excited to announce the launch of row and column-level conditional formatting in Spreadsheet.com, allowing you to create rules that automatically apply styles based on data in your worksheets.
For example, in the Inventory Management workbook below we create a rule to highlight Product rows when the quantity of Stock Units falls below 10. We also create a rule to color code Unit Price cells using a gradient based on the range of values in this column.
Inventory Management Spreadsheet
Conditional formatting is a great way to automatically highlight and call attention to specific information in your workbooks without having to manually apply styling.
Each worksheet can have any number of rules, which can be reordered based on priority, and temporarily disabled as needed. Conditional formatting styles override, but do not replace, manually applied styles.
We’ve added nine new templates to the Spreadsheet.com Template Gallery for use cases ranging from Construction and Education, to Training, Facilities, and Groups & Clubs.
For example, the new Construction Schedule for Basement Finish template from Vertex42 was created from a Spreadsheet.com workbook that was recently used for an actual home remodeling project, including a curated list of materials from The Home Depot:
Construction Schedule for Basement Finish Spreadsheet
The new Facility Management template provides the foundation of a workflow automation tool for tracking assets, completing maintenance requests, and managing inventory. It also uses the new conditional formatting feature to gray out rows when a task is marked as Complete:
Facility Management Spreadsheet
School administrators and alumni relations managers can use our new Alumni Directory template for tracking alumni information and interactions, and collecting updated alumni details using a form view:
Alumni Directory Spreadsheet
Other newly published templates include:
Employee Training (Human Resources): Training is vital for employee development, safety and productivity. This template provides a simple way to track both internal and external courses and certifications that are required and/or available to your employees.
Borrowed Items Tracker (Education): Teachers can use this spreadsheet to keep track of borrowed classroom items, the condition of each item, and the borrower’s treatment of the items. Views and filters make it easy to identify items that need replacement.
Course Scheduling (Education): Teachers and school administrators can use this spreadsheet to collaboratively plan and manage a schedule of classes for the upcoming semester. Keep track of classes, teachers, and rooms, as well as relationships between them.
Graduation Requirements (Education): College students, advisors, and counselors can use this spreadsheet to track and manage graduation requirements for students based on their major. Students can track requirements for a specific degree and other courses they would like to take.
Student Schedule (Education): Students can use this spreadsheet to track assignments and due dates along with related class information. Use views to see upcoming or overdue work, and automations to receive email reminders.
Team Roster and Game Schedule (Groups and Clubs): Youth sports usually involve parent volunteers and communication is vital for coordinating practices and games. This template from Vertex42 helps manage a roster with useful contact information for sharing with parents and guardians.
Spreadsheet.com commercial launch
In a few weeks we'll be activating our paid plans and moving your workspace to a 30 day trial of our Premium plan. You can read more about our pricing plans here. Don't worry, if you choose not to subscribe to a paid plan beyond the 30 day trial period, your workspace will be automatically moved to our Free plan. You won't lose access to any of your data.
Stay tuned for more details in the coming weeks and please contact us at support@spreadsheet.com if you have any questions about this transition.
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.
Zapier integration Spreadsheet.com is now in beta in the Zapier app directory, allowing you to create zaps that connect Spreadsheet.com worksheets with over 4,000 other apps and sites. Full launch coming soon. Login to your Spreadsheet.com account and visit Personal settings > API keys to create an API key for connecting Spreadsheet.com with Zapier. More details in the new Zapier Integration section of our Help Center.
Named ranges We're adding full support for defining and editing named ranges, as in traditional spreadsheets. Today named ranges can be imported as part of existing spreadsheets, and referenced in formulas, but cannot yet be defined and edited within Spreadsheet.com.
Select and Multiselect enhancements: define options from a range or named range We're adding the ability for options in Select and Multiselect data types to be defined from a named range or a manually specified range of cells, similar to how dropdowns are created in traditional spreadsheets with data validation. This will also work on import and export of Excel files.
Print Worksheet print capabilities are in progress. This has been a more popular feature request than we expected, and we're excited to be rolling out V1 of Print capabilities soon.
Charts We're working on initial support for floating Charts in worksheets, similar to traditional spreadsheets. This is also a prerequisite for Dashboards. Combined with Reports, this will form a trio of features that will enable a whole new level of work management in Spreadsheet.com.
