Tag Archives: Google Sheets

Google Workspace Updates Weekly Recap – March 10, 2023

1 New update

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace and G Suite customers.


Additional details for the updated Gmail experience on Android foldable devices and tablets 
Last month, we announced an improved Chat, Meet, and Gmail experience on Android foldable devices and tablets. To provide additional details on functionality, Gmail supports a 2-pane view in landscape orientation only. | This is now available. | Learn more. 


Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


Indicate your Google Voice availability with more options
We’re making it easier for you to indicate your availability in Google Voice on web and mobile. Previously, you could only indicate your availability for all of your ring groups. This update gives you greater flexibility to manage your Ring Group availability in Google Voice, without the need to sign-out of Voice or block all incoming calls using “Do Not Disturb”. | Available to Google Voice Standard and Premier customers only. | Learn more. 


Refreshed interface for Google Drive, Google Docs, Google Sheets, and Google Slides
In the coming weeks, you’ll notice a new look and feel for Google Drive, Docs, Sheets, and Slides on the web. Following the release of Google Material Design 3, the refreshed user interface is purposefully designed to streamline core collaboration journeys across our products. | Learn more. 


New updates for Google Meet on Poly Android-based appliances
We are rolling out updates to Google Meet to support our upcoming launch of Google Meet on Poly Android-based appliances. Within the Google admin console, admins can enroll Poly devices and include reporting of these new appliances. The Google Meet hardware experience will become available in the upcoming Poly OS 4.0 update as part of the Poly Studio X series family. | Learn more.


Managed Android devices must upgrade to Android Device Policy during March 2023
In 2019, we announced that a new Android management client, Android Device Policy, would replace the legacy Google Apps Device Policy client. We’re now in the final stages of this upgrade. All devices with the Google Apps Device Policy will lose access during March 2023 if they have not already upgraded. | Learn more. 


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.


Refreshed interface for Google Drive, Google Docs, Google Sheets, and Google Slides

What’s changing 

In the coming weeks, you’ll notice a new look and feel for Google Drive, Docs, Sheets, and Slides on the web. Following the release of Google Material Design 3, the refreshed user interface is purposefully designed to streamline core collaboration journeys across our products. 

In Docs, Sheets, and Slides, you’ll see improvements such as: 
  • A simplified user interface at the top of your docs, sheets, and slides, helping you find frequently used actions faster 
  • Additional user experience improvements in commenting, background, rulers, and gridlines. 
  • Note that while there are no changes in functionality, some features have been relocated to reduce clutter within the new interface. Notably, you can find the latest status info for the doc, such as last edit and version history, via a single entry point: the clock icon in the top right corner.



In Drive, you’ll see improvements such as:
  • Key actions surfaced inline on files, for quick access and increased productivity. 
  • Ability to select multiple items at a time and undertake batch operations for frequent tasks.
  • New search chips (including type, owner, and last modified) to help you find files faster.




Who’s impacted

End users

Why it matters 

These key visual and interactive design changes will help you get your best work done faster by emphasizing the tools within our products used most frequently. For more information, check out the latest on the Workspace blog.

Rollout pace


Availability


  • Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers
  • Available to users with personal Google accounts


Resources


Google Workspace Updates Weekly Recap – March 3, 2023

3 New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace and G Suite customers.


Improving Filters in Google Sheets
Filters and filter views help you analyze a set of data in a spreadsheet, and to improve upon this widely used feature, we’re introducing two updates. First, there will be a summary of the rows remaining after a filter is applied in Sheets. You will now see the number of rows that are displayed in the bottom right margin, helping you know immediately whether you are looking at the entire data set or just a subset of it. Second, with the new option to directly apply filters from the right-click menu, filters are now more accessible and discoverable. Simply right-click and apply filters directly to your data, remove them, or filter by the current cell value from the same menu. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for March 15th, 2023 | Learn more.
Programmatically manage and apply Google Drive label taxonomy changes
In 2022, we announced a highly requested update that allows admins and developers to programmatically manage labels at scale through Google Drive APIs. As a follow up, the Drive Labels API now supports taxonomy management, enabling admins and developers to programmatically add, modify, delete, and publish label taxonomy changes. | This is now available to Google Workspace Essentials, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Plus, Education Standard, and Nonprofits customers only. | Learn more. 


Expanding noise cancellation to phone participants
For select Google Workspace editions, participants who dial in by phone will have background noise removed from their audio. This helps ensure phone participants are easier to hear and understand during meetings, while removing any potential disturbing sound from the meeting. | This is now available to Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Plus, the Teaching and Learning Upgrade, and Frontline customers only. | Learn more.  



Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


Save time with suggested work locations in Google Calendar
We added an update that helps you easily define your work location much quicker with suggested working locations based on your recent locations. | Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, Teaching & Learning Upgrade, and Nonprofits, as well as legacy G Suite Business customers only. | Learn more.


All newly created spaces in Google Chat will be in-line threaded beginning March 13, 2023
As previously announced, we’re streamlining the way you organize conversations in Google Chat. Starting March 13, 2023, all newly created spaces in Google Chat will be in-line threaded. Users will no longer have the option to organize them by conversation topic, where related messages and replies were grouped together in the main conversation window. Existing spaces organized by conversation topic will continue to function as they do today. | Learn more. 


Expanding noise cancellation in Google Meet to more devices
Beginning today, noise cancellation is available for users with personal Google Accounts on a wider variety of Android mobile devices, and for Google Workspace Business Starter, Education Fundamentals, Education Standard customers. It is also enabled by default for third-party devices that connect to Meet using Pexip. | Learn more. 


Client-side encryption for Gmail is now generally available
Beginning today, client-side encryption for Gmail is now generally available for Google Workspace Enterprise Plus, Education Plus, and Education Standard customers. For customers currently enrolled in the beta, your experience will not change. | Learn more.


Google Keep notes now available on home screen of Android devices
In addition to dual pane view, drag out, and a number of other features supporting the mission to provide a top-class user experience on Android devices when using Google Keep, we’re introducing the Keep single note widget. With this new feature, you can “pin” a note or list to your home screen and edit them in the Keep app with a single tap. | Learn more.  


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.


Rapid and Scheduled Release Domains:


For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Google Workspace Updates Weekly Recap – February 24, 202

4 New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace and G Suite customers.


View your peripheral devices directly in the Google Meet green room
Before joining a Google Meet meeting, you’ll be able to instantly check which of your peripheral devices are available and connected. You can still view your peripheral devices via the settings menu, but this update makes it easier to select equipment or identify potential issues. | This is now available. | Learn more.
Improvements to sales and customer service integrations in Google Chat
Third-party sales tool Salesforce and customer service tool Zendesk are now better integrated with Google Chat, using the updated Salesforce and Zendesk Chat apps. The Salesforce Chat app now allows you to more easily search and share Salesforce records into the Chat stream. The Zendesk Chat app provides improved notifications of updates to Zendesk tickets into Chat, including the ability to update and reassign tickets. Installing these apps provides simpler access to your sales and customer service workflows directly in Chat. | This is now available. | Learn more. 
2-pane view on foldable Android devices now available for Meet, Gmail, and Chat
As part of our mission to provide a top-class user experience on large screen devices, Android foldable-device users have been able to access a 2-pane view for Google Meet and Gmail. We’re excited to announce this also includes the Chat tab in the Gmail app. | This is now available. 
Optimized zoom experience for Google Sheets on Android devices
In continuing our efforts to enhance the Google Workspace experience on Android devices, we’re introducing an improved zoom scale experience when using Google Sheets on Android devices. Upon opening the Sheets app, zoom scales are now different based on your device type. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for mid March, 2023.

Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


Introducing Trusted Types in Google Workspace
We’re improving the client-side security of Google Docs, Sheets, Slides, Forms, Sites, Jamboard, Drawings, and Drive with Trusted Types. This will provide an extra layer of protection around Document Object Model (DOM) APIs that are used by the apps listed above or third-party extensions. | Learn more. 


Introducing new smart canvas features in Google Sheets and Google Docs
We’re introducing even more smart chips and a new way to display dates across Google Sheets that will make it easier for you to quickly preview and interact with dates, locations, and financial information. We’re also adding a stopwatch chip to Google Docs that can track how long it takes to complete an activity, helping you stay on task and on time. | Learn more. 

Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.

Introducing new smart canvas features in Google Sheets and Google Docs

What’s changing

As we continue to innovate with smart canvas, we’re introducing even more smart chips and a new way to display dates across Google Sheets that will make it easier for you to quickly preview and interact with dates, locations, and financial information. Additionally, we’re adding a stopwatch chip to Google Docs that can track how long it takes to complete an activity, helping you stay on task and on time. 

Place chips: When a Google Maps place chip is added to your Sheet, you can open the location directly in Google Maps, and see a preview of the location or find directions. 
Expanded date capabilities: Include dates in your Sheet more easily using the @ entry point with shortcuts like @today, @yesterday, @tomorrow, and @date. Clicking on the date will display a date picker that allows you to update dates as needed. 
Finance chips: Add Google Finance entities, such as stocks, mutual funds, and currencies into a Sheet. Hover over the chip to preview information depending on entity type. For example, for stocks, you can see company name, listing Index, stock price, and market cap. Clicking the chip will take you to the entity’s dedicated Finance page. 

Stopwatch Chips: When a stopwatch chip is inserted, you can start, stop, and reset the timer as needed. 

Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: 
    • You can insert a finance or map chip in a Sheets cell by following one or all of the following methods: 
      • Type “@” followed by a Place or Finance entity 
      • Navigate to Insert > Smart chips 
    • Visit the Help Center to learn more about inserting smart chips in Google Sheets.
    • To insert a date and activate the date picker, type “@” followed by "date", "today", "yesterday", or "tomorrow". You can also access the date picker by double tapping manually entered dates.
    • You can insert a stopwatch chip in Docs by following one or all of the following methods: 
      • Type “@” followed by “Stopwatch” 
      • Navigate to Insert > Smart chips 
    • Visit the Help Center to learn more about inserting smart chips & building blocks in your Google Doc. 

Rollout pace 


Availability 

  • Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers 
  • Available to users with personal Google Accounts 

Resources 

Introducing Trusted Types in Google Workspace

What’s changing

We’re improving the client-side security of Google Docs, Sheets, Slides, Forms, Sites, Jamboard, Drawings, and Drive with Trusted Types. This will provide an extra layer of protection around Document Object Model (DOM) APIs that are used by the apps listed above or third-party extensions. 

This new enforcement mode will require third-party extensions to use typed objects instead of strings when assigning values to DOM APIs, and will begin rolling out on March 23, 2023. Once Trusted Types are fully enforced, the Trusted Types directive will be present in the Content Security Policy (CSP) header: 

Who’s impacted

Developers (relying on any Chrome extensions that modify DOM APIs.) 


Why it’s important

Trusted Types is a feature that further enhances our advanced data protection controls to keep users and data safe across more of the apps they use everyday. 


Additional details 

Screen readers, braille devices, and screen magnification will not change with Trusted Types. However, we recommend admins and developers check third party extensions for Trusted Types violations. Visit the Help Center to learn more about Accessibility for Google Docs, Sheets, Slides, & Drawings. 


Getting started 

  • Admins: There is no admin control for this feature. 
  • Developers: 
    • To make code Trusted Types compliant, signal to the browser that data being used within the context of these DOM APIs is trustworthy by creating a Trusted Type special object. 
    • There are several ways to be Trusted Types compliant, such as removing the offending code, using a library, or creating a Trusted Types policy. To ensure a seamless experience for users, these techniques can be employed before Trusted Types enforcement is rolled out. 
    • Visit the Chrome DevTools engineering blog to learn more about implementing CSP and Trusted Types debugging in Chrome DevTools. 
  • End users: There is no end user setting for this feature. 

Rollout pace 

Availability 

  • Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers 
  • Available to users with personal Google Accounts 

Resources 

Google Workspace Updates Weekly Recap – February 10, 2023

3 New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace and G Suite customers.


Increasing visibility into unmovable items in Google Drive
Following the recent announcement of a new beta to move folders from My Drive to shared drive, we’re launching the ability for admins to generate a CSV report with more details about unmovable items. With greater visibility into which files are impacted and unmovable, admins can then take necessary action such as request to transfer content ownership, make file copies, move content around, and more. | Available to Google Workspace Essentials, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, and Nonprofits, and legacy G Suite Business customers only. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for February 20, 2023. | Learn more.

Changing the POWER function in Google Sheets
The POWER function, which returns a number raised to a power, will now return a real-valued root when trying to take the odd root of a negative number. | This feature is available now for all users. | Learn more. 
New free-hand PDF annotation support in the Google Drive app on Android
You can now use your finger or a stylus to freely write annotations on a file shown in the Drive preview screen on Android devices. These annotations can be saved to the file if it is a PDF, or a PDF copy of the file can be made with the annotations saved to it. | Learn more.


Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


Expanding SIP Link for Google Voice to Latin America
Beginning today, we’re launching Voice to the following countries in Latin America by expanding SIP Link availability: Argentina, Colombia, Chile, Brazil, and Mexico | Customers in Latin American Countries will need to purchase SIP Link Standard or SIP Link Premier licenses to set up SIP Link. Customers in all other supported countries will need to purchase Voice Standard or Voice Premier licenses to set up SIP Link. | Learn more. 

Expanding the power of Google Sheets with localized formatting and improved CSV imports
We’re introducing updates to improve the overall Google Sheets experience for users around the world. First, Sheets will now automatically use regional-specific decimal separators based on your spreadsheet's locale. Second, we’re making it easier to import CSV files into Sheets. | Learn more.  

Include captions with a Google Meet video recording
If you’re using captions in Google Meet, you now have the option to include those captions in a meeting recording. | Available to Google Workspace Essentials, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Plus, the Teaching and Learning Upgrade customers only. | Learn more. 


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.


Expanding the power of Google Sheets with localized formatting and improved CSV imports

What’s changing

We’re introducing updates to improve the overall Google Sheets experience for users around the world. 

First, Sheets will now automatically interpret regional-specific decimal separators based on your spreadsheet's locale. For example, in France, it is more common to use commas as decimal separators. Starting today, when using a keyboard with a number pad, you can use the decimal key to insert the regional-specific decimal separator in Sheets. 
Second, we’re making it easier to import CSV files into Sheets. Previously, if you used commas (,) as your decimal separators and semicolons (;) as your text separators, you had to choose a custom delimiter and type ";" for the import to properly split text to columns. Starting today, Sheets will autodetect semicolons (;) as a way to separate text into columns. 


Getting started 

Rollout pace 

Sheets Locale: 

Semicolon autodetect in Sheets: 
  • This feature is available now for all users. 

Availability 

  • Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers 
  • Available to users with personal Google Accounts 

Resources 

Google Workspace Updates Weekly Recap – February 3, 2023

3 New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), launching to both Rapid and Scheduled Release at the same time (if not, each stage of rollout should take no more than 15 business days to complete), and available to all Google Workspace and G Suite customers.


In-line replies for email notifications in Google Classroom 
We’re making Classroom email notifications more functional and easier to use. With in-line replies for comments, teachers and students will be able to easily stay up to date and respond to communication within Classroom. Public and private comment notifications will have the freshest information, like the latest comment threads, and you can now easily respond to comments within the email itself. This will enable teachers to quickly reply to their students without having to switch back and forth between their email and Classroom. | Rollout to Rapid Release and Scheduled Release domains began January 30, 2023 and is expected to be completed by February 20, 2023. | Available to Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade customers, and users with personal Google Accounts only. | Learn more. 

Expanding color options in Google Slides, Docs, Sheets and Drawings
In Google Slides, Docs, Sheets and Drawings, you can now select colors in the color palette tool by using RGBA values. In addition, you can also customize colors by using an eyedropper tool and selecting any color on your screen within the color palette. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for February 15, 2023. | Learn more. 
More ways to work with BigQuery data in Google Sheets
We’re expanding your ability to access, analyze, visualize, and share billions of rows of BigQuery data from Google Sheets:
Available to all Google Workspace customers and users with personal Google Accounts only. Not available to legacy G Suite Basic and Business customers.


Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


Google Sheets adds powerful new functions for advanced analysis
We announced 11 additional functions that will introduce new concepts, provide you with more efficient functions, and help with more advanced analysis | Learn more.


Explore Looker data using Connected Sheets
We added the ability to interactively explore modeled data from Looker, Google Cloud’s modern business intelligence platform, using Connected Sheets. | Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, Frontline, and Nonprofits, as well as users with personal Google Accounts only. | Learn more.


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog post for additional details.

Rapid Release Domains: 

Explore Looker data using Connected Sheets

What’s changing

We’re adding the ability to interactively explore modeled data from Looker, Google Cloud’s modern business intelligence platform, using Connected Sheets. This brings connectivity between the familiar interface of Google Sheets and the 50+ data sources available within Looker’s open ecosystem, including BigQuery, Cloud SQL, Snowflake, and Redshift. 

From a single source of truth, you can analyze data using pivot tables, charts, formulas, and other integrated data sources. Additionally, with this live connection, access is secured and your data will stay up to date. 

Getting started 

  • Admins: 
    • In order for users to take advantage of this feature, make sure Connected Sheets for Looker is enabled in Looker's Admin menu. 
    • Visit the Help Center to learn more about using Connected Sheets. 
  • End users: 
    • If enabled by your admin, follow these steps to explore Looker data using Connected Sheets: 
      • In a Google Sheet navigate to “Data” > “Data connectors” > “Connect to Looker” > enter in the URL of a Looker instance, for example: https://example.looker.com. You will then need to authorize Sheets to access your Looker data. After you connect to an Explore, you can see the available data and continue your analysis in Google Sheets. 
      • Visit the Help Center to learn more about Connected Sheets for Looker. 

Rollout pace 


Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, Frontline, and Nonprofits 
  • Not available legacy G Suite Basic and Business customers 
  • Available to users with personal Google Accounts 

Resources