Category Archives: Apps Feed Blog

The feed from the Google Apps team

New chart text and number formatting options in Sheets

Quick launch summary 

We’re adding new features to help you customize chart text and numbers in Google Sheets. Specifically, you can now: 
  • Directly click on almost any chart text element and update both its content and style, most notably individual data labels and legend items. 
  • Set advanced number formatting options on both your data labels and axis labels, including the option to conditionally format by color. 
  • Use a contextual sidebar editing experience, making it easier to format individual data labels, legend items, and single data points. 
See images below for demonstrations: 

Customize the text content and style of legend items and single data labels 

Advanced number formatting of chart data and axes labels (including conditional color formatting) 

Quickly format single data columns, bars, or points using the contextual sidebar 


Getting started 

Rollout pace 

Availability 

  • Available to all G Suite customers and users with personal accounts 

Resources 

Better visualize shorter meetings in Google Calendar

Quick launch summary

In Google Calendar, events fewer than 25 minutes will now better reflect the true duration of the event, occupying less space in your daily view. This change will also show in the printed version of your calendar.


Previously, these shorter events were displayed the same as 30-minute events. With this update, we hope to make your schedule easier to understand and manage.

Getting started

Admins: There is no admin control for this feature.

End users: This feature is ON by default and can be disabled in your account settings under View options: “Display shorter events the same size as 30 minute events.” To maintain clear legibility of characters, this is OFF by default for accounts in Arabic, Chinese, Japanese, and Korean.

Rollout pace

Availability

  • Available to all G Suite customers

Dark theme now available for Docs, Sheets, and Slides on Android

Quick launch summary 

We’re enhancing Google Docs, Sheets, and Slides on Android with Dark theme support. Dark theme will intelligently adjust the product interface and user-generated content in ways that can make it more usable in low-light environments and save battery life. 

Settings for Docs, Sheets, and Slides will adjust automatically when the Android system is set to use Dark theme. You can also turn dark mode on or off for Docs, Sheets, or Slides independently. If you do this, each app will always be in the selected theme regardless of the Android system settings. 


Docs, Sheets, and Slides in Dark Theme 

Getting started 

  • Admins: No action needed. 
  • End users: This feature will automatically respect the Android system settings. Dark theme can also be enabled in the Docs, Sheets, or Slides apps individually by going to Menu > Settings > Theme > Dark in each app. When using Dark theme, you can preview your current document or sheet in the Light theme using More > View in light theme. Visit our Help Center to learn more about Dark theme in Google Docs, Sheets & Slides

Choose your theme

View in light theme 


Rollout pace 

Availability 

  • Available to all G Suite customers and users with personal accounts 

Resources 

Use Gmail alongside other iOS apps with iPad Multitasking

Quick launch summary

When using an iPad, you’re now able to multitask with Gmail and other iOS applications. You can use Gmail and Google Calendar at the same time with Split View to check your schedule before replying to an email to confirm a meeting time. Or, you can easily drag and drop pictures from Google Photos into an email without leaving Gmail.



Getting started

Admins: There is no admin control for this feature. 

End users: This feature will be available by default. To turn on Multitasking on your iPad, go to the Settings app > Home Screen & Dock > Multitasking and select “Allow Multiple Apps.” Visit the Apple Help Center to learn more.

To enter split view, when in Gmail and swipe up from the bottom of the screen to open the Dock. On the Dock, touch and hold the app you want to open and drag it to the left or right edge of your screen.

We also recommend you enable Keyboard Shortcuts for Gmail on your iPad for even more efficiency as you multitask.

Rollout pace

Availability

  • Available to all G Suite customers and users with personal Google Accounts 

Filter out disruptive noise in Google Meet

Quick launch summary 

To help limit interruptions to your meeting, Google Meet can now intelligently filter out background noise like keyboard typing, doors opening and closing, and construction outside your window. Cloud-based AI is used to remove noise from your audio input while still letting your voice through. 

We had previously announced this top-requested feature and are now beginning to roll it out to G Suite Enterprise and G Suite Enterprise for Education customers using Meet on the web. We will bring the feature to mobile users soon, and will announce on the G Suite Updates blog when it’s available. 



Getting started 


Rollout pace 

  • Now available to all web users in most countries. 
  • For users in Australia, Brazil, India, Japan, and New Zealand, extended rollout (potentially longer than 15 days for feature visibility) starting on June 30, 2020. 
  • Not currently available in some countries (currently including South Africa, the UAE, and surrounding locales). See our Help Center for more availability details

Availability 

  • Available to G Suite Enterprise, G Suite Enterprise for Education customers* 
  • Not available to G Suite Basic, G Suite Business, G Suite for Education, and G Suite for Nonprofits customers 

Resources 

Roadmap 


*Availability in alternative packages is variable and based on your services.

Connected Sheets now generally available, replacing Sheets data connector

What’s changing

We’re making Connected Sheets generally available to G Suite Enterprise and G Suite Enterprise for Education customers. Connected Sheets helps you analyze BigQuery data in Google Sheets. It was previously available in beta. Connected Sheets will replace Sheets data connector, a more limited way to connect Sheets and BigQuery.

Read more about how you can use it to analyze petabytes of data with Google Sheets in our Cloud Blog post.

Who’s impacted

End users

Why you’d use it

Connected Sheets links Google Sheets to BigQuery, so you can analyze large BigQuery datasets using familiar spreadsheet tools and operations. This means users don’t need to know SQL and can generate insights with basic spreadsheet operations like formulas, charts, and pivot tables.

This makes it easier for more members of your organization to understand, collaborate on, and generate insights from data. Specifically, it can help subject matter experts work with data without relying on analysts, who may be less familiar with the context of the data or be overloaded with a wide range of data requests.

Connected Sheets includes all the capabilities of the legacy Sheets data connector with additional enhancements. Enhancements include the ability to analyze and visualize data in Sheets without needing to first extract the data, being able to see a preview of data through a Sheet, and scheduling data refreshes to avoid analyzing stale data.

Learn more about how you can analyze petabytes of data with Google Sheets on the Cloud Blog

Getting started


  • Admins: No action required, Connected Sheets will be ON by default. To use it, you must have set up BigQuery for your organization, and users must have access to tables or views in BigQuery. Use our Help Center to learn more about how to set up Connected Sheets.
  • End users: This feature will be ON by default. To use it, must have access to tables or views in BigQuery. Use our Help Center to learn more about Connected Sheets.

Rollout pace


  • Rapid and Scheduled Release domains: Extended rollout (potentially more than 15 days for feature visibility) starting on June 30, 2020. We expect rollout to complete within a month. 

Availability 


  • Available to G Suite Enterprise and G Suite Enterprise for Education customers* 
  • Not available to G Suite Basic, G Suite Business, G Suite for Education, and G Suite for Nonprofits customers 

Resources 



Roadmap 


*Availability in alternative packages is variable and based on your services.

Update your G Suite mobile and desktop apps before August 12, 2020, to ensure they continue working

Quick summary

In 2018, we began making changes to our API and service infrastructure to improve performance and security. As a result of these changes, some older versions of G Suite desktop and mobile apps may stop working on August 12, 2020. In particular, versions released prior to December 2018 may be impacted.

To ensure their workflows are not disrupted, your users should update the following Google apps to the latest versions as soon as possible:

Getting started
  • Admins: Encourage your users to upgrade their apps. If you deploy Drive File Stream to your organization, ensure you’re using the latest version.
  • End users: Upgrade the apps listed above to the latest versions as soon as possible.
Rollout pace

Availability
  • This impacts all G Suite customers and users with personal Google accounts.

New chart axis customization in Google Sheets: tick marks, tick spacing, and axis lines

Quick launch summary 

We’re adding new features to help you customize chart axes in Google Sheets and better visualize your data in charts. The new options are:

  • Add major and minor tick marks to charts. 
  • Customize tick mark location (inner, outer, and cross) and style (color, length, and thickness). 
  • Set the precise numeric spacing between major and minor axis ticks or grid lines. 
  • Choose to show or remove the line that marks the axis. 

See how this works in the images below.
Customize the location and style of tick marks. 

Set the spacing between tick marks and grid lines. 

Choose to show or remove axis lines 


Getting started 



Rollout pace 



Availability 


  • Available to all G Suite customers and users with personal accounts 

Resources 


“Hey Google, join my meeting”: G Suite meetings now supported on Nest Hub Max in beta

Quick launch summary

We just announced the availability of Google Meet on Nest Hub Max. Over the next few weeks this feature will be rolling out to G Suite domains enrolled in the G Suite with Google Assistant beta program.

Once in the beta program, people can seamlessly join work meetings with their G Suite account. Users can say, “Hey Google, join my meeting” to call into the next meeting on their calendar, enter a specific meeting code or start a new Meet call directly from Nest Hub Max.

The flexibility of connecting to Meet this integration with Google Assistant helps your users to easily connect as a group from their own personal Nest Hub Max.


This beta program launched November 2019 and also allows G Suite users to use Google Assistant for certain Google Calendar and Gmail functions, such as:

  • Let you know when your next meeting is
  • Create, cancel or reschedule a Calendar event
  • Dial into a meeting on your mobile device
  • Send a note to event attendees via email on your mobile device
  • Send an email on your mobile device

Getting started

Admins: Apply to the beta for your organization. If your organization is already in the G Suite with Google Assistant Beta program, you will have access to this feature in the coming weeks.

End users: Once your domain is enrolled in the beta, connect your G Suite account to your Nest Hub Max to access these features. Visit the Help Center to learn more.

Availability


  • All G Suite Editions are welcome to apply to this beta program

Resources




Coming soon: manage Google Chat and classic Hangouts chat settings from one place in the Admin console

What’s changing

You'll soon be able to manage all Google Chat and classic Hangouts chat-related settings from a single page in the Admin console. This follows the update we made last year to combine several settings for Google Chat and classic Hangouts.

On July 6, 2020, we’ll start mapping your existing service status (e.g. Google Chat on, classic Hangouts on, Chat preferred off) to the new setting that matches your current user experience. You don’t need to take any action.

Most end users will not see any change. In domains where Google Chat is turned ON but classic Hangouts and Chat preferred are turned OFF, however, users will begin seeing Chat in Gmail over the next few weeks.

Visit the Help Center to learn more about the different settings options for chat.
New chat service settings in the Admin console


Who’s impacted

Admins and end users

Why it matters

With all your chat settings in one place, including on / off controls for different chat services, you can now view your organization's chat configuration holistically and more easily tailor it to your needs.

Additional details

We recommend the “Chat preferred” setting for admins who would like to transition their entire organization from classic Hangouts to Google Chat. With this launch, Chat preferred is now configurable at the organizational unit (OU) level.

While these changes are rolling out, admins may temporarily see the "Chat clients" tab as well as the new service page. They should only change the new service status page to make changes for their domain.

Please note that while the experience for most end users will not change with these new settings, in the coming weeks we’ll launch Chat in Gmail to domains that have the “Chat only” setting selected. This means that any user in a domain where Chat is turned ON and Classic Hangouts and Chat Preferred are turned OFF will start seeing Chat in Gmail. This feature was previously only available to domains with the Chat preferred setting selected. End users will have the option to turn Chat in Gmail off at the individual level.

Getting started

Admins: No action is required, as we’ll automatically align your existing settings to the new setting that matches your current user experience. Visit the Help Center to learn more about choosing a chat service for your organization.
New combined service on / off setting row in the Admin console
End users: Visit the Help Center to learn more about how to turn Chat in Gmail on or off for your account.

Rollout pace

New chat settings and page


Chat in Gmail to “Chat only” domains


Availability


  • Available to all G Suite customers

Resources