Tag Archives: Google Sheets

Use Connected Sheets with VPC-SC protected data, improved Cloud Audit Logs for Connected Sheets events

What’s changing 

BigQuery datasets that are behind a perimeter created by VPC Service Controls can now be accessed using Connected Sheets. 


We’ve also made improvements to the Connected Sheets logging in the Cloud Audit Logs. See the “Additional details” section below for more information. 


Who’s impacted 

Admins and end users 



Why you’d use it 

This change gives VPC Service Controls Admins and Editors the ability to allow members of your organization to access, collaborate on, and generate insights from VPC Service Controls protected data via Connected Sheets. 



Additional details 

By default, Connected Sheets cannot access BigQuery data that is protected by VPC Service Controls; however, VPC Service Controls perimeters can now be configured to allow queries issued through Connected Sheets to succeed. This configuration can only be changed by VPC Service Controls Admins and Editors. 



Improved Connected Sheets logging 
Whenever BigQuery data is accessed in Connected Sheets, entries are recorded for who accessed the data and when in Cloud Audit Logs. 


Now, the Cloud Audit Logs will additionally include the ID of the spreadsheet that generates the BigQuery data access. Every spreadsheet has a unique ID containing letters, numbers, hyphens, or underscores, which can be found in the Google Sheets URL. Use this documentation to learn more about where to find this additional information in the Cloud Audit Logs. 


Getting started 


Rollout pace 


Availability 

  • Available to all Google Workspace customers Available to users with personal Google Accounts 
  • Not available to legacy G Suite Basic and Business customers

Resources 

Google Workspace Updates Weekly Recap – April 29, 2022

New updates 

Updated rollout schedule for additional Calendar statuses in Google Chat 
We’d like to provide updated rollout information for additional Calendar statuses in Google Chat, previously announced on March 14, 2022: 
  • Rollout for Rapid release domains will be complete on Wednesday, May 5, 2022. 
  • Rollout for Scheduled release domains will begin on Wednesday, May 11, 2022 and is expected to be complete by Tuesday, May 24, 2022. 


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. 



Easily manage storage related activity and policies through new storage management tools in the Admin console 
In the Admin console, storage related activities can now be accessed and managed from a single source. | Learn more. 



Quick access to additional actions when composing a message in Google Chat on iOS 
When using Google Chat on iOS, you can now easily take additional actions by hovering over the plus (“+”) icon next to the compose bar. You’ll see a variety of options such as: 
  • Sharing a Google Meet link 
  • Creating a meeting in Calendar 
  • Accessing Google Drive Text formatting options and more. 




Enhanced menus in Google Docs improves findability of key features on desktop 
We’re updating the menus in Google Docs to make it easier to locate the most commonly-used features. In this update you’ll notice: 
  • Shortened menus for better navigation 
  • Reorganization for more intuitive feature location 
  • Prominent icons for faster recognition 



Warning banners alert users of suspicious Google Docs, Sheets, or Slides files on web 
Previously, we announced warning banners for potentially malicious or dangerous files in Google Drive. We’re extending these warnings at the file-level — going forward, if you open a Google Docs, Sheets, or Slides file on the web, you’ll see these warnings. | Learn more. 


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

Warning banners alert users of suspicious Google Docs, Sheets, or Slides files on web

Quick summary 

Previously, we announced warning banners for potentially malicious or dangerous files in Google Drive. We’re extending these warnings at the file-level — going forward, if you open a Google Docs, Sheets, or Slides file on the web, you’ll see these warnings. 


Getting started 


Rollout pace 


Availability 

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

Resources 

Warning banners alert users of suspicious Google Docs, Sheets, or Slides files on web

Quick summary 

Previously, we announced warning banners for potentially malicious or dangerous files in Google Drive. We’re extending these warnings at the file-level — going forward, if you open a Google Docs, Sheets, or Slides file on the web, you’ll see these warnings. 


Getting started 


Rollout pace 


Availability 

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

Resources 

Intelligent corrections for formulas in Google Sheets

Quick Summary 

Last year, we launched formula suggestions in Sheets, which recommend formulas for specific cells based on the data you are analyzing. Now, you can write formulas faster and with higher confidence with formula corrections. These intelligent, context-aware corrections help you improve and troubleshoot many different kinds of formulas. Some examples include: 

  • VLOOKUP errors 
  • Missing cells in range input 
  • Locking ranges when applying formulas across cells 

Whenever you insert a formula that Sheets detects may be improved, a suggestion box will appear with details on a new version that can replace the current formula, including the ability to accept or reject it.



Formula corrections in Sheets


For example, the above correction helps users when writing VLOOKUP functions, which only return values to the right of the matched cell. The correction suggests a combination of INDEX and MATCH functions to reverse the column order in the formula. 

Getting started 

  • Admins: There is no admin control for these features. 
  • End users: This feature will be available by default and can be disabled by going to Tools > Enable formula corrections 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 legacy G Suite Basic and Business customers, and users with personal Google Accounts. 

Resources 

Join a Google Meet call from Google Docs, Sheets, or Slides

What’s changing 

You can now join a Google Meet call from Google Docs, Sheets, and Slides. In addition to the present to Meet option, you can select “Join the call” to quickly join and present a document, spreadsheet, or presentation to all attendees, allowing everyone in the meeting to collaborate while having a conversation.



Who’s impacted 

Admins and end users 


Why it’s important 

To help teams do their best work in the hybrid work world, as many of us begin a return to office, we continue to make enhancements to Google Meet to help ensure that video meetings are inclusive and collaborative no matter the location or device preference. 

We hope this feature makes it easier for everyone in the meeting to collaborate in real-time while having a conversation—all from the same tab. 


Getting started 


Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility starting on April 12, 2022 
  • Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 2, 2022 

Availability 

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

Resources 


Roadmap 

Google Sheets doubles cell limit

Quick Summary 

We’ve increased the cell limit in Google Sheets from up to five million cells to up to ten million cells. This limit applies to new, existing, and imported files. 


Over the course of the last four years, we’ve been steadily increasing the cell limit in Google Sheets: from 2 million to 5 million in 2019 and now to 10 million. We hope this and future increases give users the ability to work with their data on a much greater scale in Google Sheets. 


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: Visit the Help Center to learn more about the current file limits in Google Sheets. 

Rollout pace 

  • This feature is available now for all users. 

Availability 

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

Resources 

View richer information about colleagues and stakeholders using people chips in Google Sheets

Quick launch summary

You can now add people chips directly into a Google Sheet. These chips allow you to quickly view more information about colleagues or contacts, including their location, job title, and contact information. You can also take actions such as booking a meeting, starting a Chat, sending an email, and more, directly from a smart chip. This feature is already available for Google Docs.


To insert a people chip, type  “@” in any cell to search your directory or by selecting Insert > People chip.


Getting started

  • Admins: There is no admin control for this feature.
  • End users: This feature will be available by default. To insert a smart chip in a cell, press “@” or by selecting Insert > People Chip. Visit the Help Center to learn more about using smart chips 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



Roadmap


Google Workspace Updates Weekly Recap – October 29, 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. 


Updating Gmail "Compose" button for Chat in Gmail users on the web 
Earlier this year, we updated the "Compose" button to a smaller, icon-only button for all users of Chat in Gmail on the web. We've heard from you that the original, larger version of the button is more intuitive and will be going back to that option starting November 3, 2021. | Available to all Google Workspace customers and users with personal Google accounts.




New navigation menus in Google Sites
Site editors can now organize page and external links under new navigation menus. Simply select "New Menu" and add or move pages to allow more flexibility in structuring navigation within your sites. | Available to all Google Workspace customers and users with personal Google accounts.


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.


Enhanced menus in Google Sheets improves findability of key features
We’re updating the menus in Google Sheets to make it easier to locate the most commonly-used features. | Learn more.


Manage and share private iOS apps through Google Endpoint Management
Admins can now upload, manage, and distribute private iOS applications to advanced managed devices. | Available to Google Workspace Enterprise Standard, Enterprise Plus, Education Standard, Education Plus, and Cloud Identity Premium customers. | Learn more.


VirusTotal integration with the security investigation tool provides deeper insight into Gmail events
Admins can use the Security  Investigation tool to view VirusTotal reports to gain richer information regarding Gmail event logs and use that information to make more informed decisions on protecting their users and data. | Available to Google Workspace Enterprise Plus, Education Standard, and Education Plus customers. | Learn more.


Improved and updated security menu in the Admin Console
We have updated the “Security” category within the left-hand navigation of the Admin console by adding navigation access to security features previously only accessible from the security settings page, introducing subcategories, and more. | Learn more.


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

Google Workspace Updates Weekly Recap – October 29, 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. 


Updating Gmail "Compose" button for Chat in Gmail users on the web 
Earlier this year, we updated the "Compose" button to a smaller, icon-only button for all users of Chat in Gmail on the web. We've heard from you that the original, larger version of the button is more intuitive and will be going back to that option starting November 3, 2021. | Available to all Google Workspace customers and users with personal Google accounts.




New navigation menus in Google Sites
Site editors can now organize page and external links under new navigation menus. Simply select "New Menu" and add or move pages to allow more flexibility in structuring navigation within your sites. | Available to all Google Workspace customers and users with personal Google accounts.


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.


Enhanced menus in Google Sheets improves findability of key features
We’re updating the menus in Google Sheets to make it easier to locate the most commonly-used features. | Learn more.


Manage and share private iOS apps through Google Endpoint Management
Admins can now upload, manage, and distribute private iOS applications to advanced managed devices. | Available to Google Workspace Enterprise Standard, Enterprise Plus, Education Standard, Education Plus, and Cloud Identity Premium customers. | Learn more.


VirusTotal integration with the security investigation tool provides deeper insight into Gmail events
Admins can use the Security  Investigation tool to view VirusTotal reports to gain richer information regarding Gmail event logs and use that information to make more informed decisions on protecting their users and data. | Available to Google Workspace Enterprise Plus, Education Standard, and Education Plus customers. | Learn more.


Improved and updated security menu in the Admin Console
We have updated the “Security” category within the left-hand navigation of the Admin console by adding navigation access to security features previously only accessible from the security settings page, introducing subcategories, and more. | Learn more.


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