Google Workspace Changes

Google Sheets adds enhanced formatting, collapsed card views, and print/download support to timeline view.

Google Sheets is expanding its timeline view feature with several new capabilities to improve project tracking. These updates include enhanced formatting options such as card text truncation and undo/redo functionality, a new card collapsed view that allows users to merge cards into a single row for each card group, and the addition of print and download support.

New capabilities to expand the timeline view feature in Google Sheets.

Today, we’re adding the following capabilities to expand the timeline view feature: Enhanced formatting options, including card text truncation and the undo/redo option, A card collapsed view that enables you to merge cards into a single row for each card group, Print and download support

Export client-side encrypted spreadsheets to Excel files

Google Sheets now supports the export of client-side encrypted spreadsheets into Excel format, allowing users to convert files as needed while maintaining their encryption protection.

New smart chip data extraction in Google Sheets allows users to pull metadata from people, file, and event chips into cells.

Google Sheets has introduced smart chip data extraction, enabling users to extract metadata associated with people, file, and event chips into their own cells. This functionality allows for advanced sorting, filtering, and analysis of data derived from smart chips. Users can perform these extractions via a dedicated sidebar or by using formulas, and can keep the extracted data current using the 'Refresh & manage' section.

Autofill using a mouse is now available on the Google Sheets Android app.

Users of the Google Sheets Android app can now utilize the autofill feature using a mouse, improving data entry efficiency on Android devices.

More control over accessibility preferences in Google Sheets

Improving the ability to adjust your accessibility preferences for Sheets separately. Rather than having the same accessibility settings apply across these products, you’re now able to set preferences for each product individually. We expect this change to make it easier to ensure accessibility settings are personalized to best meet each user’s needs.

Insert people chips in Google Sheets to view contact information and take actions.

Users can now add people chips directly into Google Sheets by typing '@' or selecting Insert > People chip. These chips allow users to quickly view detailed information about colleagues or contacts, including their location, job title, and contact information, and perform actions such as booking meetings, starting a Chat, or sending an email directly from the smart chip.

Google Sheets is updating its menus to improve the findability of key features.

Google Sheets is updating its menu bar and right-click menus to make commonly-used features easier to locate. The update includes shortening menus to prevent them from being hidden off-screen, reorganizing features into more intuitive locations (such as adding freeze row/column to the right-click menu), shortening item descriptions for faster recognition, and adding icons. These changes affect all menus, including File, Edit, View, Insert, Format, Data, Tools, Extensions, Help, and Accessibility.

New intelligent, context-aware suggestions for formulas and functions in Google Sheets.

Google Sheets now offers in-line, sequential, and context-aware suggestions for formulas and functions as users begin typing. These suggestions are designed to help users write formulas more accurately and speed up data analysis. Users can access additional incremental suggestions via a drop-down menu, and the feature can be disabled through the Tools menu or the suggestion dialog box.

Easily customize and identify theme colors in Google Sheets and Slides.

Google has updated the color picker in Sheets and Slides to make theme colors easier to find and select. The theme colors section is now located at the top of the color picker, and the theme placeholder now displays the name of the active theme, allowing users to more easily identify and apply company brand colors.

Set custom table ranges for charts in Google Sheets

Google Sheets is improving the way data is suggested and selected when creating charts. Users can now specifically select which columns to use for the chart axis and series, rather than having all data ranges on a table automatically used. This allows for quicker customization of charts to display the most relevant data when working with datasets containing slicers, pivot tables, and other elements.

Set custom table ranges for charts in Google Sheets

Improving the way data is suggested and how data is selected when creating a chart in Google Sheets. Allowing to select which columns to use for the chart axis and series

Sort and filter cells by text or fill color in Google Sheets

Added two additional parameters to filter and sort cells by in Google Sheets: Text color and Fill (background) color.

Retirement of the Sheets v3 API and migration to v4 API.

Google is retiring the Sheets v3 API and requiring developers to migrate their applications to the v4 API. Following several timeline extensions, the final turndown of all components of the v3 API is scheduled for August 2, 2021.

Update to Sheets API v4 migration timeline

Extending the timeline to allow developers additional time to migrate their applications from Sheets v3 API to the v4 API.