Tag Archives: Google Sheets

New intelligent suggestions for formulas and functions in Google Sheets

Quick summary 

You’ll now see in-line, sequential, context-aware suggestions for formulas and functions when working with data in Google Sheets. 

Formula suggestions will make it easier to write new formulas accurately and help make data analysis quicker and easier.

Simply begin inserting a formula in Sheets—suggestions will be automatically displayed and as you continue to type. You can view additional incremental suggestions in the drop-down menu.

Google Sheets will intelligently suggest formulas and functions as you work with data in Sheets.


We hope these formula suggestions make it easier and faster for you to work with and analyze your data.

Getting started

  • Admins: There is no admin control for this feature.
  • End users: This feature will be available  by default and can be disabled by going to Tools > Enable formula suggestions or from the three-dot menu of the suggestion dialog box. Visit the Help Center to learn more about using formulas and functions in Google Sheets. 

Rollout pace


Availability

  • Available to all Google Workspace customers, as well as G Suite Basic and Business customers
  • Available to users with personal Google accounts

Resources


New intelligent suggestions for formulas and functions in Google Sheets

Quick summary 

You’ll now see in-line, sequential, context-aware suggestions for formulas and functions when working with data in Google Sheets. 

Formula suggestions will make it easier to write new formulas accurately and help make data analysis quicker and easier.

Simply begin inserting a formula in Sheets—suggestions will be automatically displayed and as you continue to type. You can view additional incremental suggestions in the drop-down menu.

Google Sheets will intelligently suggest formulas and functions as you work with data in Sheets.


We hope these formula suggestions make it easier and faster for you to work with and analyze your data.

Getting started

  • Admins: There is no admin control for this feature.
  • End users: This feature will be available  by default and can be disabled by going to Tools > Enable formula suggestions or from the three-dot menu of the suggestion dialog box. Visit the Help Center to learn more about using formulas and functions in Google Sheets. 

Rollout pace


Availability

  • Available to all Google Workspace customers, as well as G Suite Basic and Business customers
  • Available to users with personal Google accounts

Resources


New intelligent suggestions for formulas and functions in Google Sheets

Quick summary 

You’ll now see in-line, sequential, context-aware suggestions for formulas and functions when working with data in Google Sheets. 

Formula suggestions will make it easier to write new formulas accurately and help make data analysis quicker and easier.

Simply begin inserting a formula in Sheets—suggestions will be automatically displayed and as you continue to type. You can view additional incremental suggestions in the drop-down menu.

Google Sheets will intelligently suggest formulas and functions as you work with data in Sheets.


We hope these formula suggestions make it easier and faster for you to work with and analyze your data.

Getting started

  • Admins: There is no admin control for this feature.
  • End users: This feature will be available  by default and can be disabled by going to Tools > Enable formula suggestions or from the three-dot menu of the suggestion dialog box. Visit the Help Center to learn more about using formulas and functions in Google Sheets. 

Rollout pace


Availability

  • Available to all Google Workspace customers, as well as G Suite Basic and Business customers
  • Available to users with personal Google accounts

Resources


Google Workspace Updates Weekly Recap – August 20, 2021

New updates 

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), 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), and available to all Google Workspace and G Suite customers.


Block shares option added to Google Drive sharing emails
Last month, we announced that you could now block shares from another user in Google Drive. es from another user in Google Drive. Now, we're also adding the option to block a user from the sharing notification emails sent from Google Drive. With this addition, you'll be able to start the workflow directly from the email. | Learn more. 


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 more insights and take quick action on the Users, Domain, and Billing home cards in the Admin console
You’ll notice important notifications and improved guidance within the cards to help you easily take action on user, billing, and domain management activities on the Admin console homepage. | Learn more. 


Upload customized audio prompts and greetings to Google Voice automated attendant
You can now upload your own pre-recorded prompts and greetings when setting up an automated attendant at Google Voice, in addition to the standard text-to-speech voice ability you currently have. | Available to all Google Workspace and G Suite customers with Google Voice standard and premier licenses. | Learn more.


Easily customize theme colors in Sheets and Slides
Now it’s easier to find and select theme colors in Sheets and Slides. | Learn more.


Share where you’re working from in Google Calendar
Starting August 30, 2021, you’ll be able to indicate where you’re working from directly on your calendar. You can add a weekly working location routine and update your location as plans change. Starting August 18, admins will be able to control how the feature is used in their organization. | Learn more.


Limit external messaging to trusted domains in Google Chat
Now, you may choose to limit external chat to people in trusted domains for your entire organization, or set different policies for different OUs. | Learn more.


Dark mode for Google Chat on web
You can now enable dark mode for Google Chat on the web (chat.google.com) and the Google Chat Progressive Web App (PWA). | Learn more.


For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Easily customize theme colors in Sheets and Slides

Quick launch summary

Now it’s easier to find and select theme colors in Sheets and Slides, the two Google Editors that support themes.


The theme colors section is now at the top color picker, and the “theme” placeholder has now been enhanced to show the name of the theme. Now you can easily identify your company brand and use the theme colors of the brand.


To select theme colors, go to any color picker dropdown and click the edit button for your theme color palette. In the theme color sidebar, select a color from the dropdown to begin editing. Note that color changes apply only to the current theme you selected and will not create a new theme.


Example of selecting customized theme colors. In this case the theme is named “Simple Light.”


We hope this new feature will help you customize your presentations in Sheets and Slides and enable you to incorporate your company’s brand colors.


Getting started

  • Admins: There is no admin control for this feature.
  • End users: This feature will be ON by default. There is no end user setting for this feature.

Rollout pace

Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on August 17, 2021


Availability

  • Available to all Google Workspace customers, as well as G Suite Basic and Business customers 
  • Available to users with personal Google Accounts

Resources

Directly open Office editing from shared links

 

Quick launch summary 

Now, when you create links to shared Microsoft Office files stored in Drive, they will open directly in Google Docs, Sheets or Slides. Previously, Office files would open in a preview mode first — this streamlined experience allows you to begin editing and collaborating on these files faster. 

This change also updates the alternateLink and webViewLink fields for shared links in the Google Drive API. 


               Office files opening without preview                                                 
Getting started 


Rollout pace 

Availability 
  • Available to all Google Workspace customers, as well as G Suite Basic and Business customers 
Resources 

Smart Compose now available in comments for Google Slides, Sheets, and Drawings

Quick launch summary

Last year, we announced Smart Compose in Google Docs, a feature that helps you compose high-quality content faster and more easily. Smart Compose saves you time by cutting back on repetitive writing, reducing the chance of spelling and grammatical errors, and suggesting relevant contextual phrases.

Now, Smart Compose is available in comments for Google Slides, Sheets, and Drawings.

Image of Smart Compose offering a suggestion in a comment
Smart Compose offering a suggestion in a comment.



Getting started

  • End users: This feature will be ON by default and can be disabled by going to Tools > Preferences and unchecking “Show Smart Compose Suggestions.” When enabled, you’ll automatically see Smart Compose suggestions. To accept a suggestion you like, press “tab” or press the right arrow key. Visit the Help Center to learn more about using Smart Compose in Google Docs, Sheets, Slides, and Drawings.

Rollout pace

  • This feature is available now for all users.

Availability

  • Essentials, Business Starter, Business Standard, Business Plus, Frontline, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Nonprofits, Cloud Identity Free, Cloud Identity Premium

Resources

Google Workspace Updates Weekly Recap – July 23, 2021

New updates

Unless otherwise indicated, the features below are fully launched or in the process of rolling out (rollouts should take no more than 15 business days to complete), 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), and available to all Google Workspace and G Suite customers.

Gmail now displays the latest emojis
Now you can see all the latest emojis in Gmail, with emojis now rendered in the latest Unicode standard 13.1.

Improved Tabular Data Handling for Gmail DLP
We are improving the way we handle Tabular data files like .csv or .xlsx to best account for the structure of these files. This will result in more accurate content scans. | Available to Google Workspace Enterprise, Education Fundamentals, Standard, Teaching and Learning Upgrade, and Plus customers. | Learn more.


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 Google Workspace Public Status Dashboard and service status alerts
We're introducing a new Public Status Dashboard experience for Google Workspace. As part of this update, we’re enhancing the functionality of the existing Apps outage alert system-defined rule, which provides email notifications regarding service disruptions or outages via the Public Status Dashboard. | Learn more.


Hangouts to Google Chat upgrade beginning August 16th, with option to opt-out
Beginning August 16, 2021, we will start upgrading users who have the “Chat and classic Hangouts” setting selected to “Chat preferred,” unless you explicitly opt out. Additionally, the “Chat and classic Hangouts'' setting will also be removed for all users in your domain unless you opt out of the upgrade. | Learn more.


Fundamental data regions now available to more Google Workspace customers
Data regions give you the ability to choose where covered data for select Google Workspace apps is stored at rest. We’re introducing a more limited version of data regions, known as Fundamental data regions, which will be available to Google Workspace Enterprise Standard, Business Plus, Business Standard and Frontline customers. | Learn more.


Bulk convert Classic Sites to new Sites using the Classic Sites Manager
Beginning today, you can now bulk convert Classic Sites to new Sites using the Classic Sites Manager. | Learn more.


Block shares from another user in Google Drive
We’re adding the ability to block another user in Google Drive. If blocked, the user will not be able to share any Drive items with you, and items owned by the user will not be able to be shared with you or be shown when you’re browsing Google Drive. In addition, your files will not be available to the user you’ve blocked, even if you’ve previously shared items with them.  | Learn more.



Select multiple tabs in Google Sheets and perform basic actions on the selection
Now you can select multiple tabs in Google Sheets and perform basic actions on the selection (such as moving the tabs together, deleting, duplicating, copying, coloring, or hiding). | Learn more.



Image placeholders make it easy to work as a team with images in Slides themes and layouts
Now when you create a theme in Slides, you can add image placeholders to your layouts. | Learn more. 



Easily collaborate and share Slide presentations with side-by-side viewing in Google Chat
In Google Chat, you can now open and edit a Slide presentation in a side-by-side view. | Learn more. 



For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Select multiple tabs in Google Sheets and perform basic actions on the selection

Quick launch summary

Now you can select multiple tabs in Google Sheets and perform basic actions on the selection (such as moving the tabs together, deleting, duplicating, copying, coloring, or hiding). Work in Google Sheets with confidence and make workflows faster as you perform basic actions on more than one sheet at a time.


GIF show how multiple tabs are selected in Sheets to be deleted together.



Getting started


Rollout pace


Availability

  • Essentials, Business Starter, Business Standard, Business Plus, Frontline, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Nonprofits, Cloud Identity Free, Cloud Identity Premium 

Resources

Google Workspace Business Starter and Frontline customers can now collaborate with people who are not using a Google account in Drive, Docs, Sheets, Slides, and Sites

Quick launch summary 

We’re making visitor sharing available to Google Workspace Business Starter and Frontline customers, with a limit of five visitor shares per month, per user. 

With visitor sharing, you can share items with non-Google accounts, enabling them to view, comment on, or edit content in Google Drive, Docs, Sheets, Slides, and Sites using a secure pincode. 



Getting started 

  • Admins: 
    • Sharing outside of your organization to users with non-Google accounts will be ON by default if you currently allow users in your organization to send sharing invitations to people outside your organization who are not using a Google account. 
    • Sharing outside of your organization to users with non-Google accounts will be OFF by default if you currently do not allow sharing outside your organization. Use our Help Center to learn more about sharing to non-Google accounts. 
    • Visitor sharing will be controlled by new settings at Admin console > Apps > G Suite > Drive and Docs > Sharing Settings (pictured below). These settings can be controlled at the domain or OU level. 



Rollout pace 


Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Frontline, and Nonprofits, as well as G Suite Business customers 
  • Not available to G Suite Basic, Cloud Identity customers, or users with personal accounts 

Resources