Tag Archives: Google Sheets

Google Workspace Updates Weekly Recap – March 22, 2024

2 New updates

Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if 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.


Search for files directly using new search bar in Google Drive
Last year, we introduced a new homepage view in Google Drive that makes it easier and faster for you to find files that matter most. Starting this week, you’ll notice an expanded search bar and enhanced search chip capabilities that enable you to filter files across your entire Drive. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 15, 2024. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about how to use Google Drive 
Search for files directly from the new homepage view in Google Drive



Improving filtering for merged cells in Google Sheets 
We’re excited to announce that users can now filter ranges with merged cells in Google Sheets. 
  • For ranges with vertical merges, users can create a filter and apply various filter types (condition, values, and color). 
  • For ranges with horizontal merges, users can create a filter, apply various filter types (condition, values, and color), and sort by values or color. 
Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 3, 2024. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about sorting & filtering your data.


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.



The current appointment slots feature in Google Calendar will be replaced by appointment schedules in July 2024 
To create a cohesive user experience in Calendar, as of July 18, 2024, the appointment slots feature will be replaced by appointment schedules. | Appointment schedules are available to Google Workspace Business Starter, Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, Nonprofits, Google Workspace Individual customers and Google One Premium users only. | Learn more about appointment scheduling.


Securely migrate existing encrypted messages to Gmail client-side encryption (CSE) 
Beginning this week, admins can migrate encrypted emails from other services like Microsoft 365, Microsoft Exchange, or Virtu, to Gmail client-side encryption in the S/MIME format. This enables Google Workspace customers to simplify the migration process by bulk importing sensitive emails as S/MIME messages without compromising their privacy or compliance posture. | Available to Google Workspace Enterprise Plus, Education Standard, and Education Plus customers. | Learn more about securely migrating existing encrypted messages to Gmail CSE.


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

 





Set up dropdown chips more easily in Google Sheets

What’s changing

In 2022, we announced the ability to create dropdown chips in Google Sheets. This custom formatting smart canvas feature enables you to easily indicate statuses or various project milestones within your spreadsheet. 

Today, we’re building upon this by introducing preset dropdowns. Instead of manually creating values for your dropdowns, you can insert preset dropdown chips that are configured for common use cases like priority or review statuses. After inserting a preset dropdown, you can use the data validation sidebar to easily adjust the options or add styles. 
Set up dropdown chips more easily in Google Sheets


Getting started 


Rollout pace 


Availability 

  • Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google account 

Resources

Smooth scrolling in Google Sheets now available on desktop

What’s changing

We’re excited to announce a highly-requested feature that improves control over your scrolling experience in Google Sheets. With smooth scrolling, you can scroll to a specific part of a row or column and stop wherever you’d like within the spreadsheet. 

This update works with all Sheets features, such as frozen rows, hidden columns, charts, buttons, comments, on right-to-left layouts, and when you use scrollbars (instead of a mouse/trackpad). 
smooth scrolling in Sheets


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: Use a trackpad, mouse or the scrollbar to access this update in new and existing spreadsheets. 

Rollout pace 

Availability 

  • Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts

Google Workspace Updates Weekly Recap – March 1, 2024

3 New updates

Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if 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.


Playback improvements to videos uploaded on Google Drive 
We’re enabling the generation and playback of Dynamic Adaptive Streaming over HTTP (DASH) video transcodes for all new videos uploaded to Google Drive. DASH transcodes provide adaptive bitrate playback, which allows users to receive higher or lower resolution playback based on aspects like their local network quality. As a result of this change, you’ll also notice: 
  • Improvements in join time (the time it takes from clicking play to actually starting playback) 
  • A reduction in re-buffering, both in normal playback as well as during playback at higher speeds 
While this feature applies to all new videos uploaded to Drive, existing videos in Drive will be updated by the end of the year. | Rolling out to Rapid Release domains and Scheduled Release domains now. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. 


Enhancing search within the Google Drive app 
We’re improving Google Drive’s search experience on iOS devices (with Android coming soon) by: 
  • Simplifying how you access query filters by introducing filter categories that are accessible directly below the search bar and include filters for File Type, Owners and Last modified. 
  • Showing you relevant query filters as you type your query, enabling you to easily select a filter and saving you the time and effort of typing out the full search. 
  • Adding the option to further refine your search after reaching the search results page. 
These updates are available now to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts using iOS devices. | We will provide an update when this is available on Android devices. | Learn more about finding files in Google Drive. 



Further extending long running queries within Connected Sheets 
Last year, we extended the timeout time from 5 minutes to 10 minutes for BigQuery and Looker. Now, the timeout time has increased to 20-30 minutes, and starting this week Connected Sheet users can view the status of a query and easily cancel it on Google Sheets. In addition to the ability to analyze data from queries that scan even larger data sets in Sheets, we hope these increased user controls give you even more oversight, especially in cases where queries might be taking a while to complete. | Rolling out to Rapid Release domains and Scheduled Release domains now. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about Connected Sheets for Looker and Analyze & refresh BigQuery data in Google Sheets using Connected Sheets.


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.



Now generally available: Import and convert sensitive Excel files into client-side encrypted Google Sheets 
You can now import and convert sensitive Excel files into Google Sheets with client-side encryption. | Available to Google Workspace Enterprise Plus, Education Plus, and Education Standard customers only. | Learn more about working with encrypted files in Sheets. 

Easily identify which unread threads are most relevant to you in Google Chat 
With multiple threads across numerous spaces, we know it can be difficult to identify which unread threads are most relevant to you. In order to provide you with more context upfront, you will now see participant avatars for unread threads in the conversation view. Without having to click to open the thread side panel, it will now be much easier to decide which threads to read and reply to. | Learn more about participant avatars for unread threads in Chat. 

Available in open beta: the Groups Admin role can now be provisioned for specific group types 
The Groups Admin role can now be assigned for security groups or non-security groups. Previously, those with the Groups Admin role had access to all groups within an organization. This change gives administrators more granular delegation of group admin responsibilities, helping limit access to the most sensitive groups to only those who absolutely need it. | Learn more about the beta for the Groups Admin role. 

New ways to annotate Google Docs 
We’re excited to announce a new feature, markups in Google Docs, which gives you more flexibility when providing feedback in a document. The new markups experience lets you add handwritten annotations to documents with a stylus or your finger when using an Android device. | Learn more about markups in Docs. 

Conduct direct 1:1 calls with people outside your video calling network on Google Meet mobile 
Earlier this year, we introduced cloud-encrypted 1:1 video calls between users in the same domain using the Meet mobile app. In the coming weeks, users from outside of your domain will be able to initiate 1:1 video calls with your users and vice versa. Admins will be able to pre-configure this functionality as on or off for their users with a new admin control. | Learn more about 1:1 calling using Google Meet mobile. 

Easily manage and secure your school’s accounts and mobile devices centrally in Google Admin console with the Endpoint Education Upgrade 
This year, we announced Endpoint Education Upgrade, which adds enterprise endpoint management features to your Google Workspace for Education edition. Using endpoint management, admins can better manage and secure the phones and tablets used across their school directly from the Admin console. | Available to Education Standard and Education Plus only. | Learn more about the Endpoint Education Upgrade. 

Set client-side encryption as the default mode for new emails, events, and files on mobile 
Admins can now set client-side encryption (CSE) to be on by default on Android and iOS for: newly drafted Gmail messages and replies, newly created Google Calendar events, and newly uploaded Google Drive files. | Available to Workspace Enterprise Plus customers only. | Learn more about client-side encryption default mode.


Completed rollouts

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


Rapid Release Domains: 
Scheduled Release Domains: 
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).  

Set client-side encryption as the default mode for new emails, events, and files on mobile

What’s changing 

Admins can now set client-side encryption (CSE) to be on by default on Android and iOS for: 
  • Newly drafted Gmail messages and replies 
  • Newly created Google Calendar events 
  • Newly uploaded Google Drive files

Client-side encryption in Gmail


Admins can now set client-side encryption as the default mode for users on both web and mobile that regularly handle sensitive data. This allows organizations the flexibility to meet their compliance and regulatory requirements and reduce the burden on change management programs. Each new email, event and uploaded file on mobile is automatically client-side encrypted with customer managed keys meaning the user is compliant with their org’s policy from the outset. For organizations with strict regulatory or sovereignty requirements, this can help them close compliance gaps by defaulting users to the preferred mode for handling sensitive data while on the go. 

For more information, check out our original announcement.

Getting started


Rollout pace


Availability

  • Google Workspace Assured Controls is available as an add-on to Google Workspace Enterprise Plus customers only. For more information, contact your Google account representative.

Resources


Now generally available: Import and convert sensitive Excel files into client-side encrypted Google Sheets

What’s changing

You can now import and convert sensitive Excel files into Google Sheets with client-side encryption. When collaborating with external and internal stakeholders, you may find yourself working across both Google Sheets and Microsoft Excel. This update keeps your work moving by layering interoperability on top of the privacy benefits of client-side encryption: users are in direct control of their encryption keys and the identity service that they choose to authenticate for those keys.


This feature was previously announced in August 2023 as part of an open beta.

Additional details 

With this release: 
  • You can only import .xslx Excel file types. 
  • Additional Excel and tabular file types are not supported. 
  • During import, unsupported Excel features in Sheets will be ignored. 
  • The maximum file size is 10MB. 
  • The maximum number of cells that can be imported is 10 million. 

Getting started

Google Workspace Updates Weekly Recap – February 16, 2024

2 New updates

Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if 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.



New formatting sidebar in Google Docs, Slides and Sheets apps on Android Tablets 
This week, we’re further improving the Google Workspace experience on large screen Android devices by adding a new formatting sidebar in Google Docs, Slides and Sheets. In addition to meeting the Google Material Design 3 guidelines, this new sidebar reduces the number of taps needed to navigate to formatting options, enabling you to more easily arrange text, tables, images and more. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for March 6, 2024. | Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. 
New formatting sidebar in Google Docs, Slides and Sheets apps on Android Tablets
New sidebar experience in Google Docs on an Android tablet 

Easily drag and drop an image to replace the background in Google Slides
Hovering over the border of an empty slide before dropping in an image (from your desktop, Content Library or another webpage) will now set the image as the background in Google Slides. Dropping the image anywhere else will simply insert the image onto the slide. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for February 26, 2024. | Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about changing the theme, background, or layout in Google Slides.
Easily drag and drop an image to replace the background in Google Slides

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 Meet “companion mode” is now supported on your mobile device for great hybrid meetings
Beginning this week, you’ll be able to use companion mode with your Android and iOS devices. | Learn more about Google Meet companion mode. 

Creating more immersive presentations in Google Slides
Starting this week, Speaker spotlight in Slides, an experience that lets presenters insert their video feed directly into their Slides content, is generally available for select Google Workspace editions. With Speaker spotlight, you can deliver your message with greater impact by embedding your camera feed directly into your Slides presentations. This feature helps keep your audience focused on you and can help make your content more compelling. | Available to Google Workspace Business Standard, Business Plus, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, and Education Plus customers only. | Learn more about speaker spotlight.

Assign mobile device management admin privileges based on organizational unit
We’re giving admins more granular control over how mobile device management privileges are delegated. Specifically, admins can be assigned privileges for specific organizational units (OUs). | Learn more about mobile device management. 

Sort, filter and manage comments faster in Google Docs, Sheets and Slides
We’re introducing an improved comments experience in Google Docs, Sheets, and Slides to help you find and take action on comments easier than ever before. While you will continue to see and interact with the comments experience you’re familiar with, you’ll also notice updates to our comment cards, icons, and more. | Learn more about comments across Workspace. 


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 2, 2024

3 New updates

Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if 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.


New ways to work with filters in Connected Sheets for Looker and Connected Sheets for BigQuery 
  • With Looker: Connected Sheets for Looker users will now be able to see whether Looker-defined filters, always_filters and conditionally_filters, are applied in their Google Sheets. | Rolling out to Rapid Release domains and Scheduled Release domains now. | Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about always_filter and conditionally_filter in Looker. 
  • With BigQuery: Connected Sheets for BigQuery users can now right-click any value in the Connected Sheets preview and filter rows in the preview on that specific value. As a result, a new query will be sent to BigQuery to re-fetch the preview. This new option provides an additional way to easily explore data in the Connected Sheets preview for BigQuery. | This is now available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about sorting & filtering BigQuery data in Google Sheets.

Latest improvement for page setup in Google Docs 
We’re introducing a new menu item within the Format option that enables you to easily switch between pageless and pages mode in Google Docs. | Rollout to Rapid Release domains is complete; launch to Scheduled Release domains planned for February 5, 2024. | Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about changing a document’s page setup. 
Latest improvement for page setup in Google Docs


Developers can now choose which calendar events to be notified about 
Developers using the Calendar API can now subscribe to specific changes in users’ calendars — this includes event types such as working location, out-of-office, or focus time. This update reduces the amount of notifications down to those that are most relevant to the developer. | Use our Developer Documentation for more information about subscribing to alerts for specific calendar event changes. | Rolling out now to Rapid Release domains and Scheduled Release domains. | The Calendar API is available to all Google Workspace customers, however Calendar features may vary across Google Workspace editions.



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.


For Google Meet Hardware, ‘Auto-Update Expiration (AUE)’ will now be referred to as 'end of Meet support' 
We’re making changes to the terminology that refers to when a Meet hardware device is no longer supported. | This update impacts all Google Workspace customers with Meet hardware devices. | Learn more about 'end of Meet support'.

Local data storage exports your organization's Workspace data into the geographic location of your choice, launching in beta 
We’re introducing Google Workspace’s new feature, local data storage. This feature allows admins to export their organization’s Workspace data into the geographic location or locations of their choice. | Available to Google Workspace Enterprise Plus customers with Assured Controls add-on only. | Learn more about the local data storage exports beta.

Improving the Google Calendar appointment scheduling experience with new features 
We’re improving upon the current appointment scheduling experience with four new features. | Co-hosts, secondary calendars and delegate access features are available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, and Nonprofits only. Check Calendars for availability feature is available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, Nonprofits, Google Workspace Individual subscribers, and users with personal Google accounts only. | Learn more about the appointment scheduling features. 

Shareable class templates and classwork in Google Classroom are now generally available 
Last year, we announced a Google Classroom beta that simplifies lesson planning with shareable class templates and classwork. We’re excited to announce that this is now globally available for Google Workspace for Education Plus customers in English, Spanish, Portuguese and Japanese. | Available to Education Plus only. | Learn more about shareable class materials. 

Pin chat messages in Google Meet 
You can now pin messages to the top of the meeting chat. Pinned messages will appear for all users, even if they join the meeting after the message was initially sent. | Learn more about messaging pinning.


Completed rollouts

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

Rapid Release Domains: 

Scheduled Release Domains: 
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 – January 12, 2024

4 New updates

Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if 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.


Version history limits for Apps Script projects 
For all new scripts, you’ll be able to create and save up to 200 versions of your script. If needed, you can permanently delete a script version from the project history page. | This is available now to all Google Workspace customers. | Learn more using our developer documentation on working with Apps Script versions. 


Share a link to a specific time in a Google Drive video 
We’re adding new functionality to the Drive sharing button that lets you share timestamped links to specific parts of a video. On web, simply navigate to drive.google.com > find and open a video file > play the video (you can pause the playback before performing the following steps) > select the dropdown on the “Share” button in the top-right corner > select “Copy link to this time” > send the link. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to all Google Workspace customers and users with personal Google Accounts. | Learn more about copying a specific time in the video. 
Share a link to a specific time in a Google Drive video

Introducing dropdown options on the sharing button in Google Docs, Sheets, Slides and Drawings We’re adding a new feature that ensures a seamless sharing experience across Workspace. In Google Docs, Sheets, Slides and Drawings, you will now see a dropdown on the Share button that surfaces quick actions, such as pending access requests and the “Copy link” option. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to all Google Workspace customers and users with personal Google Accounts. 
dropdown options on the sharing button

Using functions in Connected Sheets for BigQuery 
Today, Connected Sheets for BigQuery supports 23 Sheets functions, such as AVERAGE and XLOOKUP. However, all of these functions behave somewhat differently than their native counterparts. Thus, to help Connected Sheets users write better functions, we now display context-aware Help Center content in Sheets. The ‘formula help’ shows descriptions for Connected Sheets functions when writing a formula that would query BigQuery, and otherwise shows descriptions of native Sheets functions. | This is available now to all Google Workspace customers and users with personal Google Accounts. | Learn more about the XLOOKUP function.
Using functions in Connected Sheets for BigQuery


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.


Updates to metrics in Google Drive Apps Reports and Reports API 
We’re making some updates to the Google Drive metrics in the Admin Console Apps reports and the Reports API. As a result of these improvements, admins who analyze metrics will have more reporting clarity and can better understand activity trends within their domain. | Learn more about metrics in Drive Apps Reports and Reports API. 

Easily share Google Drive files to Google Calendar meeting attendees 
We’re introducing the option to share any file with all meeting participants on a Google Calendar invite via the sharing dialog within a file. | Learn more about sharing Drive files to Calendar. 

Google Meet is now available on Logitech Android appliances 
Google Meet is now supported on Logitech’s Rally Bar and Rally Bar Mini Android-based appliances for collaboration rooms and spaces of just about any size. After initial setup, admins can easily enroll, manage, and monitor these devices using the Google admin console. Google Meet on Logitech Android-based devices is supported on CollabOS v1.11 as a video conferencing provider | Learn more about Meet on Logitech Android appliances. 

Google Meet hardware devices from Poly now support interoperability with Cisco Webex and Zoom 
We’re expanding the existing interoperability between Google Meet, Cisco Webex, and Zoom to include Android-based Meet hardware devices from Poly. Specifically, these devices include: Poly Studio X30, X50, X52, and X70. | Learn more about support interoperability with Cisco Webex and Zoom.

Extending Trusted Types to Gmail
We’re excited to announce the expansion of Trusted Types to Gmail. This will provide a defense against DOM XSS and further enhances our advanced data protection controls to keep users and data safe across more of the apps they use everyday. | Learn more about Trusted Types.


Completed rollouts

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

Rapid Release Domains: 

Scheduled Release Domains: 

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). 

Set client-side encryption as the default mode for new emails, events, and files

What’s changing

Admins can now set client-side encryption (CSE) to be on by default for:

  • Newly created Gmail messages, Google Calendar events. 
  • Newly created Google Docs, Sheets, and Slides files.
  • Newly uploaded Google Drive files.

Admins can set client-side encryption as default on for users in Organizational Units (OUs) that regularly handle sensitive data requiring additional encryption. This allows organizations the flexibility to meet their compliance and regulatory requirements and reduce the burden on change management programs. Users are prompted to create a CSE object natively in each app meaning their emails, events and files are encrypted by default with customer-managed keys and are private from Google. For organizations with strict regulatory or sovereignty needs, this can help them close compliance gaps by defaulting users to the preferred mode for handling sensitive data.  

Drive:


Gmail:

This is available on the web initially, with support coming for mobile apps in the future. 

Who’s impacted

Admins and end users


Why it matters

This feature is important for Google Workspace admins as it improves users compliance behavior without sacrificing productivity and increases control for admins implementing data control policies. It also includes improved audit logs, providing more detail for admins compiling regulatory compliance reports.

Workspace already uses the latest cryptographic standards to encrypt data by default, at rest and in transit between our facilities. Client-side encryption goes beyond this, giving organizations authoritative control and privacy as the sole owner of private encryption keys and the identity provider of the encryption keys. It gives organizations higher confidence that any third party, including Google and foreign governments, cannot access their confidential data. Users can continue to collaborate across their preferred apps in Workspace while IT and compliance teams can ensure that sensitive data stays compliant with regulations. 


Getting started

Rollout pace


Availability

  • Google Workspace Assured Controls is available as an add-on to Google Workspace Enterprise Plus customers only. For more information, contact your Google account representative.

Resources