Tag Archives: Google Docs

Sort, filter and manage comments faster in Google Docs, Sheets and Slides

What’s changing

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. 

You can explore new and familiar ways to interact with comments by going to View > Comments and selecting: 
  • Show all comments: opens up a full-length view to deep dive into multiple comments more easily in Docs, Sheets or Slides. Now you can use updated search and filter functionality to focus on the most relevant comments. You will also notice a curated ‘For you’ list, which surfaces all the comments you need to take action on. 
  • Expand comments (in Google Docs and Slides): shows comments next to the document or presentation content so you can review comments and content together. 
  • Minimize comments (in Google Docs and Sheets): reduces comments to icons so you can have a more focused view of your work in Docs and Sheets. This setting provides a quick preview with high level information about who is commenting when you hover over the minimized icons. 
  • Hide comments: hides comments from view when you want to focus solely on the content in Docs, Sheets or Slides. 
manage comments faster in Google Docs, Sheets and Slides

Who’s impacted 


End users 


Why you’d use it 

With this update, you can now find and organize comments more easily, enabling seamless collaboration with others on Google Docs, Sheets and Slides. 

Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: This feature will be ON by default and cannot be disabled. To open the full-length panel, go to View > Comments > Show all comments. Visit the Help Center to learn more about using comments, action items, & emoji reactions 

Rollout pace 

Availability 

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

Resources 

Sort, filter and manage comments faster in Google Docs, Sheets and Slides

What’s changing

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. 

You can explore new and familiar ways to interact with comments by going to View > Comments and selecting: 
  • Show all comments: opens up a full-length view to deep dive into multiple comments more easily in Docs, Sheets or Slides. Now you can use updated search and filter functionality to focus on the most relevant comments. You will also notice a curated ‘For you’ list, which surfaces all the comments you need to take action on. 
  • Expand comments (in Google Docs and Slides): shows comments next to the document or presentation content so you can review comments and content together. 
  • Minimize comments (in Google Docs and Sheets): reduces comments to icons so you can have a more focused view of your work in Docs and Sheets. This setting provides a quick preview with high level information about who is commenting when you hover over the minimized icons. 
  • Hide comments: hides comments from view when you want to focus solely on the content in Docs, Sheets or Slides. 
manage comments faster in Google Docs, Sheets and Slides

Who’s impacted 


End users 


Why you’d use it 

With this update, you can now find and organize comments more easily, enabling seamless collaboration with others on Google Docs, Sheets and Slides. 

Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: This feature will be ON by default and cannot be disabled. To open the full-length panel, go to View > Comments > Show all comments. Visit the Help Center to learn more about using comments, action items, & emoji reactions 

Rollout pace 

Availability 

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

Resources 

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

Use comments & action items on your client-side encrypted Google Docs

What’s changing 

You can now collaborate with others on client-side encrypted Google Docs to add, edit, reply, filter, or delete comments. You can also assign action items to yourself or others. This added functionality helps bring parity to unencrypted docs while also ensuring your data is behind encryption keys you control, including the identity provider used to access those keys. 


This feature is available as an open beta, which means you can use it without enrolling in a specific beta program. While this feature is available for Google Docs initially, with support coming for Google Sheets and Slides in the future.




Additional details

Note that when sharing encrypted files, you can only assign “viewer” or “editor” permissions — the “comment only” permission is not supported.


Comments are saved each time the document is autosaved. If you restore the document to a previous version, the comments added to the document in that version are also restored.

Getting started

Rollout pace



Availability

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

Resources


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

Easy access to people, documents, building blocks and more in Google Docs

What’s changing 

Building upon the recently introduced row of buttons at the top of your newly created Google Docs, we’re adding more ways to quickly find and insert relevant content directly into your document with an additional way to open the @-menu. This is another feature that boosts productivity and saves time by bringing smart canvas features to the forefront of your workflow.

When moving to a blank line within your Doc, you will see an “@” button with the option to select, search and insert smart chips, such as people, dates, timers, file chips, building blocks, calendar events, groups and more. 
Easy access to people, documents, building blocks and more in Google Docs


Getting started 


Rollout pace 

Availability 

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

Resources 

Easily fill in smart chips in Google Docs using placeholder chips

What’s changing

To build on our innovations in smart canvas that help you simplify workflows and complete common tasks with easy-to-use prompts in Google Docs, we’re introducing placeholder chips. 

When crafting content in Docs, a replaceable chip for people, dates, files, events, and places can be inserted and quickly filled in by collaborators. Upon hovering or clicking on a chip, a search menu opens and includes results filtered to the chip type. Placeholder chips are particularly useful in building blocks, custom building blocks, tables, and more. 
Easily fill in smart chips in Google Docs using placeholder chips


Getting started 


Rollout pace 


Availability 

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

Resources 

eSignature is now generally available for Google Workspace Individual subscribers

What’s changing 

Earlier this year, we introduced eSignature for Docs and Drive in beta. Today, eSignature for Docs and Drive is rolling out in general availability for all Workspace Individual customers. 


Built directly into Google Docs, eSignature makes it easier for solopreneurs and small businesses to request signatures, keep track of and manage contracts like customer agreements, vendor contracts, stakeholder sign-offs and more. eSignature can be used to: 
  • Request signatures, see the status of pending signatures, and find completed contracts. 
  • Sign official contracts directly within Google Drive, eliminating the need to switch apps or tabs. 
  • Create a copy of any given contract so it can be used as a template to initiate multiple eSignatures requests.



Since the last announcement, we’ve expanded functionality to include the following features:
  • Audit trail: all completed contracts will automatically contain an audit trail report.
  • Multi-signer: the ability to request a signature from more than one user.
  • Non-Gmail users: the ability to request an eSignature from non-Gmail users.
  • Initiating eSignature on PDF (beta): the ability to initiate an eSignature on PDF files stored in Drive.

We’ll also be introducing more features for eSignature in the next few months, including:
  • PDF templates: the ability to easily reuse a PDF file as contract templates.
  • Custom text fields: the ability to ask signers to add relevant information (e.g. job titles, email address) to the contract. 


Additional details

Select Google Workspace editions (see the “Availability” section below) can apply to beta test eSignature using this form. We will be accepting beta applications until December 18, 2023.


This feature will be available as part of a larger beta, which includes access to new custom email layouts in Gmail. These new email layouts allow users to customize existing templates, reuse a custom layout in multiple email campaigns, or create a brand new layout from scratch. Once you sign up for the beta you will see the eSignature and new Gmail features in the coming weeks.

Getting started


Rollout pace


Availability

  • Available to Google Workspace Individual Subscribers 

  • Eligible for beta: Google Workspace Business Standard, Business Plus, Enterprise Starter, Enterprise Standard, Enterprise Plus, Enterprise Essentials, Enterprise Essentials Plus, Education Plus, and Nonprofits customers

Resources


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


Solve math equations easily with Smart Compose

What’s changing

For years, users have written content and replied to comments faster and more easily using Smart Compose in Google Docs, Slides, Sheets and Drawings. Today, we’re excited to announce a new feature that extends the power of Smart Compose to help you solve simple math equations. 

Upon typing a math equation that ends with “=” into your document, presentation, spreadsheet comments, or drawing, solutions will appear as grey text suggestions. This new seamless mathematical experience will increase productivity and accuracy when solving math equations across Workspace. 
Solve math equations easily with Smart Compose


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: This feature will be ON by default and can be disabled by opening a file, clicking Tools > Preferences > deselect “Show Smart Compose suggestions”. Visit the Help Center to learn more about using Smart Compose and Smart Reply. 

Rollout pace 

Availability 

  • Available to Google Workspace Business Starter, Business Standard, Business Plus, Essentials Starter, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, and Nonprofits 

Resources