U-M Google Updates

Two new features in U-M Google

4/16/2020

Google has announced two new features for the U-M Google domain:

Sort and filter cells by text or fill color in Google Sheets

Soon you will be able to sort and filter cells in Sheets by text or fill (background) color. To use this feature, select Data from the toolbar, and then select Create a filter. Finally, at the top of the range, click the Filter icon, select Sort by color or Filter by color and then choose the type (text or fill) and color you want. Matching cells will be displayed at the top of the range. To learn more about sorting and filtering data in Sheets, visit Google’s Help Center.

Create and use multiple signatures in Gmail

Soon you will have the ability to create and use multiple email signatures in Gmail. This feature gives you the flexibility to use different signatures for different situations. To create multiple signatures in Gmail, click the Settings (gear icon) > select Settings > select General. Then, scroll down to “Signature” and select “Create New” to enter a new signature. Finally, to choose one of your signatures, open the signature menu in the compose action toolbar of an email. To learn more about multiple signatures in Gmail, visit Google’s Help Center.

According to Google, the Sheets feature should now be available and the Gmail feature should begin showing up in on April 22 in U-M Google. The Gmail feature could take 15 days or longer to become fully visible.

Reminder: Only use Google apps with U-M Google

4/15/2020

This is a reminder that using third-party apps to connect to a U-M Google account can lead to unexpected results. 

Google-Created Apps and Applications

Apps and applications created by Google provide the most seamless experience when using Google services, particularly with mobile devices. Google-created apps and applications are also supported by Google, whereas third-party apps are not. We strongly recommend that only apps and applications created and supported by Google be used to connect to U-M Google accounts for these reasons. A web browser may also be used.

Third-Party Apps and Applications

Third-party apps and applications are created by a group or company other than Google. Google does not support the use of third-party apps or incidents that might result from using them. Using apps not provided by Google is at your own risk and could lead to university data loss. We have seen issues related to the use of third-party applications when used with Google services.

Some reported issues include:

  • Email and calendar events permanently deleted.
  • Inaccurate calendar notifications sent to event invitees.

These types of issues have occurred using an iPhone or iPad and Apple’s native mail and calendar apps. However, unexpected behavior is not limited to iPhones and iPads. Third-party desktop applications such as Apple Mail and Calendar or Microsoft Outlook may also cause unexpected behavior.

Be aware of the apps you use with your U-M Google account. Google provides and supports apps for Gmail, Calendar, Drive, and more in the Apple App Store and Google Play Store. Using only the apps provided by Google ensures that we can get support from Google when issues arise. 

New out of office notices in Gmail

4/3/2020

Last year, Google announced the ability to see when someone is out of office in Gmail, specifically when composing a new email or Hangouts Chat. Now, they’re expanding that functionality to more places in Gmail on the web, like when you’re hovering over someone’s name in your inbox or in the “To” or “From” line in an email.

Screenshot of the new contact info showing out of office notices in Gmail

This feature gives visibility to your time out of office in more places across G Suite, making it clear to senders the appropriate time to message you.

These notices will automatically appear when anyone whose calendar you have access to has an out of office event scheduled. Use the Google Help Center to learn more about disabling the sharing of availability information to other G Suite apps. 

Important: This feature stems from your Google Calendar out of office settings, not the vacation responder in Gmail. As a reminder, only use MCommunity for your out of office notifications and not Gmail’s vacation responder. MCommunity has been specifically designed to work within the U-M computing environment. Using Gmail’s native feature has been known to cause issues with recipients of out of office messages. For more information on how to set your away message in MCommunity, see ITS’s documentation page.

According to Google, this feature is available now in the U-M domain.

U-M Google March Monthly Summary

4/2/2020

The monthly U-M Google Summaries inform the university community of Google releases for Core Apps as well as the Non-Core Apps (those that are not part of the G Suite for Education agreement). We communicate important information on Core Apps throughout the month. Core and Non-Core Apps are listed on the G Suite website.

Core Apps:

In order to help the university community secure their Hangouts Meet sessions, the ITS Collaboration Services team created a quick guide with steps to ensure your meetings stay private and free of unwanted attendees.

In Google Docs, you will soon be able to position an image in a fixed place, ensuring it stays in a certain spot on the page and is not disrupted by text and other elements. Google has also added a new sidebar where you can quickly access other image formatting options such as size, rotation, and brightness/contrast settings.

To position an image on a Doc page, click the image and select “Fix position on page” from the menu bar below it. To open the “Image options” sidebar, click the three-dot overflow menu and then select “All image options” from the same menu bar below the image. To learn more about formatting images in Google Docs, see this article from Google's Help Center.

Screenshot of new Google Docs image positioning feature

In Google Sheets, it will soon be easier to locate and select the data you need when creating a dashboard over a dataset with slicers, pivot tables, charts, and more. Previously, all data ranges on a table would be used when creating a chart. Now, you’ll be able to select which columns to use for the chart axis and series. This allows you to quickly customize your charts so that they display the most relevant data.

In the chart editor, you can select a column as the X-axis. Under “Series” then select additional columns to populate your chart.

GIF of Google Sheets, setting custom table ranges for charts

 

Temporary premium Hangouts Meet features now available

3/23/2020

At the beginning of March, Google announced they would extend temporary access to some premium Hangouts Meet features until July 1, 2020. These features are now available within the U-M domain:

Important: U-M Google is not HIPAA-compliant. Review the Sensitive Data Guide for types of data permitted for use with Hangouts Meet. If HIPAA-compliance is needed, check out the BlueJeans conferencing service 

(retiring May 1, 2021).

To learn more about using Hangouts Meet: