Tag Archives: Google Sheets

Google Workspace Updates Weekly Recap – November 10, 2023

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.


Timeline view in Google Sheets now available on Android & iOS 
In 2022, we introduced an interactive timeline view that allows you to track projects in Google Sheets. We’re excited to announce that you can now view your timelines on Android and iOS. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for November 15, 2023. | Timeline viewing is available to all Google Workspace customers and users with personal Google Accounts. | Learn more about timeline view in Sheets. 


Adding timezone support for existing smart chips in Google Docs 
To more accurately represent time across the world, we’re introducing timezone support for existing date+time smart chips in Google Docs. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for November 27, 2023. | Available to all Google Workspace customers and users with personal Google Accounts. | Learn more about inserting smart chips & building blocks in your Google Doc. 
timezone chip in docs


Improved toolbars in the Google Docs, Sheets and Slides apps on Android devices 
We’re introducing enhanced toolbars in the Google Docs, Sheets and Slides apps that are optimized for Android tablets and foldables, and ultimately improve the editing experience across the apps. 
  • In Docs, there is a new mode switcher that allows you to switch between editing, suggestion, and viewing modes. 
  • In Slides, you will have access to an ever-present toolbar while in editing mode. 
  • In Sheets, a cell will be selected by default upon opening the app. 
Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for November 28, 2023. | Available to all Google Workspace customers and users with personal Google Accounts. 
Mode switching in the Google Docs app
Mode switching in the Google Docs app



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.



Add GIFs and stickers in Google Slides 
We’re bringing GIFs and stickers directly into Google Slides to empower you to build visual, dynamic, and creative presentations that help you connect with your audience in Slides. | Learn more about GIFs and Stickers in Slides. 

Make more informed decisions using Classroom analytics 
We’re introducing analytics in Google Classroom, providing a centralized view of Classroom data and insights for educators and education leaders. | A Google Workspace for Education Plus license is required to access this feature for both education leaders and educators. | Learn more about assigning licenses in the Help Center and about Classroom analytics.

Google Meet API now available in Developer Preview 
The Google Meet API will give partners and customers the ability to create and configure Meet video conferences, allow their end users to join a conference, and post real-time updates from within their own applications.| Available now through the Google Workspace Developer Preview Program. | Learn more about Google Meet API. 

Streamlining the user experience in Google Chat to help you find what you need much faster 
A redesigned navigation panel brings direct messages and spaces together and introduces shortcuts, a new framework to help you stay on top of your messages. To reduce friction while navigating between messages, home helps you quickly catch up on any new activity across all conversations in a single location. Finally, mentions give you visibility into the messages addressed specifically to you. | Learn more about the new Google Chat. 

Filter by people or groups in Google Drive 
We’re adding a new filter to Google Drive that lets you see which files or folders have been shared with specific people or groups. | Learn more about filters in Drive.

Improvements for scheduling large scale meetings on the web
We’re making several changes which will make scheduling large scale meetings (up to 100k guests per event) easier and guide schedulers through the process with more context. Once you’ve created and saved a Calendar event which contains a large group of attendees, you can open the event to check on the invitation progress. | Learn more about large scale meetings in Calendar.

Introducing a new homepage in the Google Drive app 
We’re updating the homepage of the Google Drive mobile app on Android and iOS mobile devices to help you more easily find the right file much faster. An updated suggested view will allow you to see even more recommended files at once, such as those that have been recently opened, shared or edited. In addition, we’re replacing the notifications view with activity view, which recently launched on web. | Learn more about the homepage in Drive.


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.


Scheduled Release Domains: 

Rapid and Scheduled Release Domains: 



Google Workspace Updates Weekly Recap – October 6, 2023

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.


Add emoji reactions to comments in Google Sheets 
Earlier this year, we introduced the ability to add emoji reactions to existing comments in Google Docs. We’re excited to announce this is now available on comments in Google Sheets, increasing collaboration by enabling you to quickly and creatively express your opinions about spreadsheet content. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for October 19, 2023. | Available to all Google Workspace customers and users with personal Google Accounts. | Learn more about using comments, action items, & emoji reactions. 
Add emoji reactions to comments in Google Sheets


Filter by filter only fields and parameters with Connected Sheets for Looker 
We’re adding support for two additional field types for filtering in Connected Sheets for Looker: filter only fields and parameters. These new options will give you even more ways to explore the semantic layer of your data as you will now be able to recreate advanced filtering in Looker explorers or dashboards using Connected Sheets for Looker. | Rolling out to Rapid Release domains and Scheduled Release domains now. | Available to all Google Workspace customers and users with personal Google Accounts. | Learn more about filter only fields and parameters in Looker.


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.


Configure and bind multiple Android Enterprise Mobility Management providers 
You can now bind multiple Android enterprise mobility management providers (EMM) to your Google Workspace account. Previously, you could only bind a single EMM within your organization. This update gives you more control over how devices in your organization are managed. | Learn more about Android Enterprise Mobility Management providers. 

Configure Android zero-touch devices directly from the Admin console 
We’re integrating the Android Zero-Touch iFrame with the Admin console for a better, more seamless experience for admins. Zero-Touch devices are devices which have been purchased from Zero-Touch resellers and used in company owned mode. | Available to Google Workspace Business Plus, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Teaching and Learning Upgrade, Education Plus, Frontline Starter, Frontline Standard and Cloud Identity Premium customers only. | Learn more about Android zero-touch devices. 

New Google Calendar appointment scheduling features 
To improve upon the current appointment scheduling experience, we’re adding: five to fourteen minute appointment slots that are customizable and the option to hide or show Appointment schedules within the calendar view on web. | Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, Nonprofits, Workspace individual subscribers, and users with personal Google Accounts only. | Learn more about Calendar appointment scheduling features. 

Navigate to Chrome Browser management faster in the Admin console 
In the Admin console, we’ve added a dedicated category for Chrome Browser admin capabilities in the left-hand navigation menu. | Learn more about Chrome Browser management. 

Improved search results in Google Chat 
When searching in Chat, machine learning models will use the search term(s), most recent Chat conversations in direct messages and spaces, and other factors to help you find more accurate and relevant Chat message results. | Learn more about search results in Chat. 

Presented content will be captured in higher definition in Google Meet recordings 
For recorded meetings in Google Meet, we’re increasing the maximum resolution for shared content from 720p to 1080p. This will help ensure crisper text and visuals for presented content, creating a better viewing experience. | Available to Google Workspace Business Plus, Business Standard, Education Plus, Enterprise Essentials, Enterprise Plus, Enterprise Standard, Enterprise Starter, and the Teaching and Learning Upgrade customers only. | Learn more about higher definition in Meet recordings. 

Build content quickly in Google Docs with instant access to building blocks and more 
We’re introducing new buttons at the top of your Google Doc that enable you to quickly insert building blocks for different types of content, such as meeting notes, email drafts and more, directly into your document. | Learn more about building content in Google Docs using building blocks. 

Allow users to install and run any internal app from Marketplace 
We’re introducing a new admin setting to control whether users can install and run any internal app from the Google Workspace Marketplace along with their allowlisted third-party apps. | Learn more about internal apps in Marketplace. 

Review and approve your Contacts delegates by November 12, 2023 
In May 2023, we announced several changes for Contacts delegates, specifically that they will be able to update labels and manage “Other” contacts. We’d like to share an updated timeline for this change and provide additional clarity around what’s required of users. As part of this change, you must review and approve your existing delegates by November 12, 2023 or they will lose their delegate status. | Learn more about Contacts delegates. 

New view in Google Drive shows recent activity in one place 
We’re rolling out a new view in Google Drive that shows all pending access requests, recent comments, and approvals for files to help you quickly see recent activity and take action, all in one place. | Learn more about activity in Drive.


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:




Google Workspace Updates Weekly Recap – September 29, 2023

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.

Improved paste values experience in Google Sheets 
Previously, when pasting a number in Google Sheets using Paste special > Values only, the content pasted was only the text from the original range of cells. For example, for the date 9/21/2023, paste values only would paste the date serial number of 45190. To improve upon this feature, the default for paste values for numbers will include values and the number format, meaning all of your numbers will retain their formatting as you are working in Sheets. | Available now to all Google Workspace customers and users with personal Google Accounts. 
Improved paste values experience in Google Sheets
Different certificates for signing and encrypting messages in Gmail 
If your organization uses different certificates for signing and encrypting messages, you can now use the Gmail CSE API to upload different encryption and signature public certificates for each user. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for October 9, 2023. | Available to Google Workspace Enterprise Plus, Education Plus, and Education Standard customers. | Visit the Help Center to learn more about using the Gmail CSE API to manage user certificates. 


Allow certificate mismatches for client-side encrypted messages 
In some cases, the email address associated with a user’s certificate might be different from their primary email address — this is known as a certificate mismatch. Admins can now opt to allow certificate mismatches, which means their end users will be able to decrypt and read messages with a mismatch. It should be noted that we recommend allowing certificate mismatches only when this feature is absolutely required for our organization. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for October 9, 2023. | Available to Google Workspace Enterprise Plus, Education Plus, and Education Standard customers. | Visit the Help Center to learn more about allowing certificate mismatches for client-side encrypted messages in Gmail.


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.


Create, modify, and insert email templates within Groups messages 
When you’re using Groups to send messages, you can save a composed message as a template to reuse in the future. | Learn more about email templates within Groups messages. 

Additional space manager capabilities in Google Chat 
We’re adding two new controls to the list of space manager capabilities in Google Chat that were introduced earlier this year to ensure effective conversations take place in spaces. The new “Manage apps” and “Manage webhooks” options will allow space managers to control the ability of space members to add and remove apps and webhooks to a space. | Learn more about new space manager capabilities. 

Easily link to a specific message in Google Chat 
Building upon the recent updates in Google Chat, such as message views, in-line replies and larger spaces, we’re introducing message linking, an additional feature that helps teams collaborate more effectively. | Learn more about message linking. 

Easily add or remove groups of members to a space in Google Chat 
We’re introducing a new app for Google Chat called Bulk Member Manager that enables space managers and space members, who have permission to manage members, to easily add or remove members to or from a space in bulk. | Learn more about the Bulk Member Manager app. 

The next phase of digital whiteboarding for Google Workspace 
In late 2024, we will wind down the Jamboard whiteboarding app as well as continue with the previously planned end of support for Google Jamboard devices. | This update impacts all Google Workspace customers who use the Jamboard app or 55-inch Jamboard device. | Learn more about the winding down of the Jamboard whiteboarding app. 

Updates regarding the transition from spaces organized by topic to in-line threading in Google Chat 
In 2022, we introduced in-line threading for Google Chat and since March 2023, all newly created spaces in Google Chat are in-line threaded by default. On September 30, 2023, we will begin taking the next step toward a single, streamlined flow of conversation in Google Chat: all existing spaces organized by conversation topic will be upgraded to the in-line threaded experience. We’d like to share more information regarding the migration, what to expect, as well as what’s next for Google Chat. | Learn more about in-line threading in Google Chat. 

Client-side encryption in Gmail is now available on mobile devices 
We’re expanding client-side encryption in Gmail to Android and iOS devices, so you can read and write encrypted messages directly from your device. | Learn more about client-side encryption in Gmail on mobile devices.

Beginning September 30, 2024: third-party apps that use only a password to access Google Accounts and Google Sync will no longer be supported 
Google Workspace will no longer support the sign-in method for third-party apps or devices that require users to share their Google username and password. | Learn more about Access to Less Secure Apps (LSA).



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:



Google Workspace Updates Weekly Recap – September 15, 2023

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.


Insert links in the Google Sheets app on iOS devices 
We’re adding the ability to insert a hyperlink into a cell in the Google Sheets iOS app by selecting a cell > clicking “+” in the top left corner > Insert > Link. If a cell contains a link, you’ll see options to edit or remove the link. | Available to all Google Workspace customers and users with personal Google Accounts. | Visit the Help Center to learn more about working with links & bookmarks. 
Insert links in the Google Sheets app on iOS devices


Enhanced spam protection through automatic labeling of suspected spam messages in Google Voice 
If you're using Google Voice, you're familiar with our suspected spam caller warnings. We're extending this feature to SMS messages on Android and iOS devices. You'll see these labels within the message, and you can either: 
  • Confirm a suspected spam message, which causes future messages from that number to go directly into the spam folder. 
  • Mark a labeled message as not spam, after which the suspected spam label is never displayed for that number again. 
Available to Voice Starter, Standard, and Premier customers, as well as users with personal accounts in the US. | Rolling out now to Rapid Release and Scheduled Release domains at an extended pace (potentially longer than 15 days for feature visibility). 
Enhanced spam protection through automatic labeling of suspected spam messages in Google Voice



Birthday decorations for people cards 
In Google Contacts and across various Google Workspace products, you’ll begin to notice birthday decorations when hovering over another user’s people card. This small change can have a big impact on building deeper connections with your colleagues and stakeholders. Birthday decorations will be displayed on your birthday if you’ve added your birthday to your Google Account profile and you’ve set the information to be visible to others. | Available now for all Google Workspace customers and users with personal Google Accounts. | Visit the Help Center to learn more about your Google Account profile and what information others can see.
Birthday decorations for people cards
Add an organizational unit as an attribute in your external directory 
When using Directory Sync, you can now place users from the Azure Active Directory or Active Directory to a specific organizational unit on the Google Workspace side. To do so, you’ll need to add an organizational unit as an attribute in your external directory. This makes it easier to sync users who will be mapped to different organizational units on the Google Workspace side. | Directory Sync is available as an open beta to all Google Workspace customers. | Visit the Help Center to learn more about setting up users to sync based on an organizational unit attribute.
Add an organizational unit as an attribute in your external directory


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.


Dual Display on Poly Studio X Series Makes Video Meetings More Productive 
We are excited to announce dual display support for Google Meet on the Poly Studio X Series to help make video meetings more productive. With dual displays, you can see more meeting participants, presentations, and documents at once, which can help you stay focused and engaged in meetings. | Available to Google Workspace customers with Poly Studio X50, X52, and X70 devices only. | Learn more about Dual Display on Poly Studio X Series.

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:

Google Workspace Updates Weekly Recap – September 8, 2023

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


Expanding autocorrect to Google Chat on web 
Google Chat on web will now automatically correct misspelled words, making it easier to send messages without typos. Similar to functionality in Gmail and Google Docs, the corrected words are shown with a gray underline so you know when the auto-correction has occurred. | This feature is rolling out now to all English users.
Expanding autocorrect to Google Chat on web

Expanding streamlined file organization across Google Workspace 
Earlier this year, we introduced streamlined file organization with the new Google Drive location picker. As a follow up, we're expanding this updated visual experience to Google Docs, Sheets, Slides, Drawings, Sites and Gmail. Users will now have access to helpful suggestions when moving files, adding shortcuts to files, or creating copies of files. | Rolling out now to Rapid Release and Scheduled Release domains at an extended pace (potentially longer than 15 days for feature visibility). | Learn more about how to use Google Drive. 

Updated zoom in/out capabilities across Google Docs, Slides and Drawings
We’re introducing new zoom keyboard shortcuts in Google Docs and Slides on web to help you zoom in, zoom out, or scale to 100%. Additionally, you can now smoothly zoom in or out in Slides using the trackpad or mouse wheel with a modifier key (cmd/ctrl), making it easier to control your view of Slides. | Learn more about keyboard shortcuts for Docs and Slides. 

Expanded language support for captions in Google Meet 
Captions in Google Meet allow you to view captions as everyone speaks during a meeting. Over the course of the next several weeks, you’ll be able to use captions in more languages: 

Arabic (Arab Emirates) (Beta)

Arabic (Egypt) (Beta)

Arabic (Levant) (Beta)

Arabic (Maghrebi) (Beta)

Bengali (Bangladesh) (Beta)

Bulgarian (Bulgaria) (Beta)

Chinese (Simplified) (Beta)

Chinese, Mandarin (Traditional) (Beta)

English (UK) (Beta)

Gujarati (India) (Beta)

Hindi (Beta)

isiXhosa (South Africa) (Beta)

Kannada (India) (Beta)

Khmer (Cambodia) (Beta)

Kinyarwanda (Rwanda) (Beta)

Malayalam (India) (Beta)

Marathi (India) (Beta)

Northern Sotho (South Africa) (Beta)

Sesotho (South Africa) (Beta)

Swati (South Africa) (Beta)

Swedish (Sweden) (Beta)

Tshivenda (South Africa) (Beta)

Tswana (South Africa) (Beta)

Xitsonga (South Africa) (Beta)

Available now to all Google Workspace customers. | Visit the Help Center to learn more about using captions in Google Meet.

Dynamic groups now supports negation queries 
You can now create or edit dynamic groups to use negation in membership queries. For example, you can opt to create a dynamic group that excludes all users from a particular sub organization or specific job title. There are a few limitations, however — any query using the “exists” macro and using the AND (&) operator or queries where the NOT operator is used inside of the “exists” macro will not be supported. | Rolling out to Rapid Release and Scheduled Release domains at gradual pace (up to 15 days for feature visibility) starting September 11, 2023. | Available to Google Workspace Frontline Standard, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus and Cloud Identity Premium customers only. | Visit the Help Center to learn more about creating membership queries for dynamic groups and our Developer documentation for more information about formulating and testing a membership query. 
Dynamic groups now supports negation queries

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 branding and customization capabilities to Google Sites 
You can now easily and quickly create with high-quality, pre-designed themes for Google Sites. | Available to Business Plus, Enterprise Standard, Enterprise Plus, Education Plus only. | Learn more about changing how your Google Site looks. 

Introducing a new ultra-low latency viewer experience for in-domain live streaming in Google Meet 
We are introducing a new ultra-low latency viewing experience for video meetings that are streamed within an organization. The new experience will be available to the first ten thousand viewers — all additional viewers will have the existing experience. | Learn more about in-domain live streaming in Google Meet. 

More Google Meet features for Google Workspace Individual users 
If you’re a Google Workspace Individual user, you can now take advantage of several new Meet features and enhancements. We hope these updates make it easier for you to connect and collaborate with your customers and stakeholders, continuing to drive your business forward. | Learn more about features for Google Workspace Individual users. 

Lock files more easily in Google Drive 
We’re adding the option to lock Drive files by right-clicking the file, selecting “File information”, and clicking “Lock”. Locking a file makes sure reviewers can’t change a file. Edits, comments and suggestions can't be added to locked documents. | Learn more about locking files in Drive.

Increased row limits in Connected Sheets for BigQuery 
We’re increasing the maximum number of rows of results returned from BigQuery for pivot tables and for data extracts. Pivot tables have been expanded to 50,000 rows (previously 30,000) and data extracts have been expanded to 50,000 rows (previously 25,000). | Learn more about Connected Sheets for BigQuery.


Increased row limits in Connected Sheets for BigQuery

What’s changing

Connected Sheets provides the power and scale of a BigQuery data warehouse in the familiar context of Google Sheets. Starting today, we’re increasing the maximum number of rows of results returned from BigQuery for pivot tables and for data extracts: 
  • Pivot tables have been expanded to 50,000 rows (previously 30,000) 
  • Data extracts have been expanded to 50,000 rows (previously 25,000) 
With the increase in row limits, you can now analyze even more rows of results in Sheets from the petabytes of data in BigQuery. Additionally, we’ve made performance improvements for pivot tables and extracts in Connected Sheets, including updates to creating a pivot table, deleting an extract, cut/copy/pasting data in a pivot table, inserting a row, deleting a column, and more.


Getting started 

Rollout pace 

Availability 

  • Available to all Google Workspace customers and users with personal Google Accounts 

Resources 

Import and convert sensitive Excel files into client-side encrypted Google Sheets

This announcement was made at Google Cloud Next ‘23. Visit the Workspace Blog to learn more about latest security updates and the next wave of AI innovation in Workspace.


What’s changing

Launching in open beta, you can now import and convert sensitive Excel files into Google Sheets with client-side encryption. Your encrypted Excel file won’t be changed, even as you change the encrypted Sheets file.

In Google Sheets, navigate to File > Import.


Additional details

With this release:
  • You can only import encrypted .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 20MB.
  • The maximum number of cells that can be imported is 5 million.

Getting started

Rollout pace

Availability

  • Available to Google Workspace Enterprise Plus, Education Standard and Education Plus customers

Turn ideas into action using Google Sheets

This announcement was made at Google Cloud Next ‘23. Visit the Workspace Blog to learn more about the next wave of AI innovation in Workspace. This feature is exclusive to the Duet AI for Google Workspace Enterprise add-on.

What’s changing

Through Duet AI for Google Workspace, you can now use Google Sheets to quickly get started organizing your data in a straightforward, highly-visual manner. By simply describing what you want to accomplish using Help me organize, Sheets will generate a plan, tracker, budget, schedule, and more in the form of a template with sample text and smart chips that are easily editable. Once inserted into the grid, you can make the template your own by assigning owners, updating statuses, and bringing in relevant information such as location or time. 


Whether you’re a travel agent planning a trip for a company retreat or a team lead establishing onboarding plans for new hires, Help me organize gives you a running start for creating highly-organized plans, trackers, timelines and more. 
Turn ideas into action using Google Sheets

Who’s impacted 

End users 


Why it’s important 

Through the power of Duet AI for Google Workspace, you can now get started organizing information faster than ever before in Google Sheets. 


Additional details 

Help me organize makes template tables with sample data, and does not have access to the data within your spreadsheet or elsewhere. 


Getting started 

  • Admins: This feature will be ON by default and there is no admin control for this feature. Visit the Help Center to learn more about Duet AI for Google Workspace Enterprise.
  • End users: 
    • To use the Help me organize feature, write a description of what you need in the sidebar > click Create > View the generated table preview. 
      • Note: You must write a minimum of 2 characters in the sidebar. The maximum number of characters is 150. 
    • The Help me organize sidebar is surfaced for any empty tab (new or existing Sheets files). 
    • You can re-open Help me organize from the insert menu or the toolbar via a new icon. You can also re-trigger the sidebar when adding a new tab. 
    • Visit the Help Center to learn more about organizing with Duet AI in Google Sheets. 

Rollout pace 

Availability 

Resources 

Google Workspace Updates Weekly Recap – August 25, 2023

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.


Copy space member email address in Google Chat 
Space managers and members can now copy the email addresses of members in a space on Google Chat. This option is ON by default for spaces with 100 members or less. The option to copy space member email addresses will be disabled in spaces with 100+ members. 
Copy space member email address in Google Chat

Filter by expression for Connected Sheets for Looker 
You can now use common filter expressions from Looker such as “last 30 days”, “last quarter”, or “NOT 50” to filter on pivot tables in Connected Sheets for Looker. | Learn more about 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.


View speaker notes while co-presenting Google Slides in Google Meet
Co-presenters are now also able to view speaker notes. | Available to Google Workspace Business Standard, Business Plus, Enterprise Starter, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Plus, the Teaching & Learning Upgrade, and Workspace Individual customers only. | Learn more about viewing speaker notes while co-presenting Google Slides in Google Meet. 

Stronger protection for additional sensitive actions taken in Gmail 
Last year, we introduced stronger safeguards around sensitive actions taken in your Google Workspace accounts. We’re extending these protections to sensitive actions taken in Gmail. | Learn more about stronger protection in Gmail. 

See message view counts in Google Chat spaces 
Space members can now see view counts for messages in all spaces. | Learn more about view counts in Google Chat spaces. 

View & compare script versions with Apps Script project history 
We're announcing project history, a new interface for developers to view previously deployed script versions and compare versions to the current script version. | Learn more about Apps Script project history. 

Displaying Microsoft Outlook users as organizers in Google Calendar 
Microsoft Outlook user who organize meetings are now listed amongst the other meeting attendees in Calendar as the meeting organizer. | Learn more Microsoft Outlook organizers in Google Calendar. 

Introducing Workday app for Google Chat 
We’re adding a new Workday app for Google Chat that allows you to perform quick actions in Workday, such as requesting time off, filing expense reports and looking up colleague's information, all without leaving Google Chat. | Learn more about the Workday app for Google Chat.

Join client-side encrypted meetings from your mobile device 
You can join a client-side encrypted meeting directly from the Google Meet and Calendar apps. | Available to Google Workspace Enterprise Plus, Education Standard, and Education Plus customers hosting client-side encrypted calls only. | Learn more about client-side encrypted meetings from your mobile device. 

Third-party app access enhancements for Google Workspace for Education 
All Google Workspace for Education Admins must review and confirm access settings for third-party configured apps that are currently accessible to your users by Oct 23, 2023 in order for users designated as under 18 to maintain access to those third-party apps. | Available to Education Fundamentals, Education Standard, Education Plus, and the Teaching and Learning Upgrade only. | Learn more about third-party app access. 

Enhance your Google Keep notes on Android with rich text formatting 
We’re adding rich text formatting options to new notes on Keep. This highly requested feature enables you to customize and add emphasis to your text through bolding, underlining, italicizing, and heading styles. | Learn more about rich text formatting on the Keep app.


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:

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 – August 18, 2023

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.


Get started with smart canvas in Google Sheets 
When opening a new spreadsheet or tab in Google Sheets, you will now see “Type @ to insert” to help you start using the smart canvas features available in Sheets. 
Get started with smart canvas in Google Sheets

A new look for Google Docs, Sheets, and Slides apps on Android devices 
We’re introducing a modernized visual design for the Google Docs, Sheets, and Slides apps on Android devices. In the coming weeks, Android users will notice a refreshed look for things like the editing toolbar, icons, background colors, and more. 
A new look for Google Docs on Android devices
Refreshed visual design of Google Docs app

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.


Programmatically read and write working locations with the Calendar API, now generally available 
Previously available in beta through our Developer Preview Program, the ability to read and write a user’s working location using the Calendar API is now generally available. | Available to Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade and Nonprofits customers, as well as legacy G Suite Business customers only. | Learn more about Calendar API. 

Google Voice users can manage incoming calls across individuals and groups 
Admins can now designate specific Voice users as managers of a ring group, allowing them to make changes from voice.google.com instead of the Admin console. | Available to Google Voice Starter, Standard and Premier customers only. | Learn more about managing incoming calls. 

Resolve conflict accounts faster with the new Conflict Accounts Management tool 
We’re introducing an automated workflow to help reduce the manual effort needed to turn unmanaged accounts into managed accounts. Unmanaged accounts are users who independently created a Google account using one of your organization's domains. | Learn more about the new Conflict Accounts Management tool. 


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: