U-M Google Updates

U-M Google November Monthly Summary

12/7/2022

The monthly U-M Google summaries inform the university community of new Google releases and previously communicated updates.

Updates:

Google has introduced an interactive Timeline View that allows you to track projects in Google Sheets. This new visual layer displays project information stored in Sheets, such as the task start and end date, description, and owner. To create a Timeline, navigate to Insert > Timeline, select a data range, and configure the attributes in the timeline settings sidebar. Learn more about creating and editing a Timeline View in Sheets.

Scrolling through an example Google Sheet with Timeline View

Google is making it easier to share files with the people you typically share with in Google Drive. A list of suggested recipients will now appear in the sharing dialog box when you click Share on a file in Drive.

Google Drive sharing dialog box with red box around new suggested users to share with

  • Use “smart chips” in Google Sheets as links on mobile 

Currently, you’re able to quickly add people and files into Google Sheets with smart chips (i.e., using @) on the web. These chips will now be treated like linked text on mobile devices and will show relevant hovercards and context menu items.

  • Resizing Pivot Tables in Google Sheets

You can now resize the pivot table editor side panel when creating or editing a pivot table in Google Sheets. This functionality is especially useful when the names of columns or fields are too long, and you want to see the text in its entirety. Learn more about creating and using pivot tables in Sheets.

  • Enhancing spell check in Google Docs

In Google Docs, words whose spelling is not recognized will now be underlined in red, even if there is no suggestion. When you click on a word, you'll see it labeled as an "unknown word," and you can then choose to add the word to your personal dictionary or ignore the suggestion. This feature is only available in English at this time.

Misspelled word highlighted in red with new pop-up stating it's an unknown word

  • Improved hearing aid support for Google Meet on Android

Google has expanded Google Meet hearing aid support on Android devices to recognize a wider variety of hearing aid devices. Meet will automatically default to using hearing aid support when they’re connected. You can also select hearing aids during a meeting from the audio settings menu. If the hearing aid has a built-in microphone, this microphone will be used. If it doesn’t, the mobile phone or tablet microphone will be used.

  • Share Google Docs, Sheets, and Slides files in Google Meet chat 

If you are presenting or joining a Google Meet session from a Docs, Sheets, or Slides file, you can now easily share that file with meeting attendees through in-meeting chat. With this update, you’re able to grant access to a document, spreadsheet, or presentation to all or specific meeting attendees. Learn more about using Google Meet with Docs, Sheets, and Slides.

Previously Communicated:

None for the month of November!

U-M Google October Monthly Summary

11/15/2022

The monthly U-M Google summaries inform the university community of new Google releases and previously communicated updates.

Updates:

You can now reply directly to any message in new and existing unthreaded spaces. This creates a separate in-line thread where smaller groups of people can continue a conversation on a specific topic, similar to Slack’s in-line threading. Moving forward, newly created spaces will feature in-line threading by default.

User opens new in-line thread in Google Chat and views the thread content

With the new right-side thread navigation panel, you can browse through all the threads in the space and filter just for threads you’re following or where you’re specifically mentioned.

Additionally, beginning in early 2023, the option to create spaces organized by conversation topic (i.e., threaded spaces) will be removed, and in-line threading will become the default for all new spaces. Existing threaded spaces will not be impacted. More information to come, according to Google.

Learn more about using Spaces, organizing a space, and managing a space with in-line threading

You can now add Google Drive files directly into a Google Sheet as a smart chip to quickly preview and interact with files in Sheets. This feature is already available in Google Docs. Learn more about inserting smart chips in Google Sheets.

User types an "@" into a cell in Google Sheets and selects a file to add to the cell

In addition to the new ability to add smart chips for Drive files in Sheets, you can now also add Google Calendar events. Once placed in your Sheet, you can view the event name and an actionable hover card in the cell, which includes an overview of attendees, times, and other meeting metadata. Learn more about inserting smart chips in Google Sheets.

Google has expanded interoperability with Google Meet and Jamboard with the new option to join or start a meeting directly from Jamboard on the web (as you can with Docs, Sheets, and Slides). This feature is available on the web. Learn more about collaborating with Jamboard in Meet.

As they did earlier with Docs and Sheets, Google is now updating the menus in Google Slides and Google Drawings to make it easier to locate the most commonly-used features.

You can now split table cells into a desired number of rows and columns in Google Docs.

To split cells, right-click the table cell, select Split cell, enter the number of rows and columns you want, and click Split. Learn more about adding and editing tables in Docs.

User right-clicks in multiple table cells in a Google Doc table and selects Split cell

Google has added three features to improve the Google Chat and Gmail search experience on web and mobile. These features include:

  • Search suggestions: Search query suggestions based on your past search history in Chat will now appear as you type in the Chat search bar.
  • Gmail labels: You can now search messages under a specific Gmail label in the mobile app to return results only within that label. You can also use search chips in the Gmail search bar to refine label searches.
  • Related results: For Gmail search queries that return no results, related results will be shown.

Learn more about search in Gmail and searching for Google Chat messages

  • See when colleagues are out of the office on Android

When viewing an individual’s information card in Google Calendar, Gmail, and Chat on Android, you are now able to see their out-of-office status via an out-of-office banner. This feature is already available on iOS devices.

  • Improved experience for the Calendar guest list in Google Meet

To help participants run effective hybrid meetings, in addition to seeing the RSVP status of everyone on the meeting invite, you'll now see all information from the Google Calendar guest list, including: 

  • Working Location 
  • Out-of-office status 
  • If the meeting is outside of an invitees working hours 
  • If an invitee is joining from the meeting room

Previously Communicated:

Notice: Google Hangouts will finally retire on November 1, 2022

Final Reminder: Google Hangouts will retire on November 1, 2022

10/25/2022

As a final reminder of Hangouts’ retirement, classic Hangouts on the web will redirect to Google Chat on the web, and Hangouts will no longer be accessible beginning November 1, 2022.

According to Google, some conversations won’t automatically migrate from classic Hangouts to Chat. If you would like to keep an archive of your old conversations (including any files sent via Hangouts) in case they did not migrate from Hangouts to Chat, you can do so by using Google Takeout. You will have until January 1, 2023, to export and download your classic Hangouts data before it is purged from Google’s systems and the service is shut off.

Learn how to use Google Takeout to export and download your classic Hangouts data.

U-M Google September Monthly Summary

10/24/2022

The monthly U-M Google summaries inform the university community of new Google releases and previously communicated updates.

Updates:

Google has improved the notifications you see when editing a Microsoft Office-formatted file in Google Drive. These improvements include:

  • An Office-formatted warning symbol for compatibility details that will appear while working within a document, spreadsheet, or slide deck. This indicates potential compatibility issues or if any Office features are unavailable.
  • An option to easily view and restore earlier versions of the document, spreadsheet, or slide deck.

Learn more about working with Office files using Office editing

Google has introduced a new feature in Google Sheets called “named functions.” Named functions allow you to create custom functions that support built-in Sheets formula constructs. To maintain reusability across files, you can also import named functions from existing Sheets files.

Walkthrough of creating a new named function in a Google Sheets spreadsheet

In Sheets, navigate to Data > Named functions > Add new function to create your new function. You can then enter your custom formula into a Sheets’ cell as you would any other formula.

Named functions created in a Sheets file are available only in that file. To use named functions in another Sheet, select that file via Data > Named functions > Import function. Learn more about named functions in Sheets

  • Quickly mute/unmute yourself with the spacebar in Meet

To quickly unmute yourself during a Google Meet call, you can now hold down the spacebar to be unmuted, then release the spacebar to return to a muted state. This feature is off by default and can be enabled in your Google Meet settings. During a session, click the three-dots icon next to the red Leave call button, select Settings, and toggle Push to talk to ON (in the Audio tab).

To search for and add emojis directly inline with text in Docs, follow one of the options below: 

  • Type “@:” or “:” to see a drop-down list of emojis and the option to navigate to the entire catalog of emojis.
  • Type “@” followed by a descriptor, such as “@smile,” to search for a specific emoji.

Learn more about inserting emojis and special characters in Docs.

Walkthrough of using @ to insert an emoji in a Google Doc

  • Insert Google Maps "place chips" into Google Docs 

Last year, Google added the ability for you to insert a Google Maps “place chip” into a Google Doc by pasting a Maps link directly into the document. Now, you can insert place chips into your Docs using “@[address or place name].” Learn more about using place chips in Docs.

  • Notification permissions now required for devices running Android 13

Upon upgrading your Android device to the latest Android 13 release, you will have to explicitly accept notification permissions to receive Google Chat and Gmail notifications. Learn more about notification permissions on Android 13

You can now share meeting artifacts (such as attendance reports, other documents, etc.) directly with the meeting co-hosts in Google Meet. Previously, some Meet features would generate meeting artifacts that were only shared with the meeting host.

To share meeting artifacts directly with the co-hosts, the primary host needs to: 

  • Add individuals as co-hosts when setting up or editing the event in Google Calendar.
  • Check the “Call artifacts are shared with the host and co-hosts you add here” box when you add co-hosts in Calendar.

Google Meet video call options menu

Learn more about sharing meeting artifacts with co-hosts in Meet

You will now see options for Spanish, French, and Portuguese while using Smart Reply in Google Chat. When you are typing a reply, Smart Reply will automatically detect the language and offer responses accordingly.

  • Send multiple images or videos at a time in Chat

You can now select more than one image or video at a time when sending a message in Google Chat.

  • Multi-pinning available for Meet on Android and iOS

Earlier this year, Google added multi-pinning for Google Meet on Chrome. You can now use multi-pinning on Android and iOS devices, too. With this feature, you can pin up to three participants’ video tiles at once to keep them fixed on your screen. Learn more about multi-pinning in Meet

You can now use spacers to add empty space to your Google Sites in specific places. In a Site draft, add spacers by clicking Spacer from the Insert panel on the right. Learn more about adding a spacer between elements in Sites.

Users of screen readers can now type a keyboard shortcut to verbalize the content/details of a Google Calendar event, such as the title, date and time, guest list, and more.

Use the following keyboard combinations: 

  • ALT+{number} for Windows 
  • Option+{number} for Mac
  • ALT+SHIFT+{number} for ChromeOS 

Learn more about the new Google Calendar keyboard shortcut for screen reader users.

Previously Communicated:

None for the month of September!

Notice: Google Hangouts will finally retire on November 1, 2022

10/11/2022

Over the last few years, Google has been slowly retiring classic Google Hangouts in favor of its replacements: Google Chat and Meet. As part of the final stage of the retirement of Hangouts, classic Hangouts on the web will redirect to Google Chat on the web, and Hangouts will no longer be accessible beginning November 1, 2022.

According to Google, some conversations won’t automatically migrate from classic Hangouts to Chat. If you would like to keep an archive of your old conversations (including any files sent via Hangouts) in case they did not migrate from Hangouts to Chat, you can do so by using Google Takeout. You will have until January 1, 2023, to export and download your classic Hangouts data before it is purged from Google’s systems and the service is shut off.

Learn how to use Google Takeout to export and download your classic Hangouts data.