Tag Archives: Google Sheets

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).

Enhanced menus in Google Sheets improves findability of key features

What’s changing 

We’re updating the menus in Google Sheets to make it easier to locate the most commonly-used features.

In this update: 

  • The menu bar and right-click menus have been shortened to better fit your screen to prevent menus from being hidden off screen
  • Some features were reorganized and added to more intuitive locations (for example, you can now freeze a row or column from the right-click menu) 
  • Some descriptions of items in the menu are shorter, enabling faster recognition 
  • Icons have been added to help you locate features more easily 
  • Changes are across all menus, including File, Edit, View, Insert, Format, Date, Tools, Extensions, Help, and Accessibility. 

Example of updated menu in Google Sheets


Example of updated menu in Google Sheets
Example of updated menu in Google Sheets

Example of updated menus in Google Sheets

Who’s impacted 

End users 

Why it’s important 

The new design improves findability of key features, making it quicker and easier to use Sheets, especially on devices with smaller screens. 

Additional details 

Some of your favorite menu items may have moved a little, but all existing functionality is still available. We hope that their new home will be more intuitive and make it easier and faster to navigate the product.

Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: This feature will be ON by default and cannot be disabled. Use the menus as you would regularly and enjoy the new look and feel. Visit the Help Center to learn more about using Google Sheets

Rollout pace 

Availability 

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

Resources 

Predicting Spreadsheet Formulas from Semi-structured Contexts

Hundreds of millions of people use spreadsheets, and formulas in those spreadsheets allow users to perform sophisticated analyses and transformations on their data. Although formula languages are simpler than general-purpose programming languages, writing these formulas can still be tedious and error-prone, especially for end-users. We've previously developed tools to understand patterns in spreadsheet data to automatically fill missing values in a column, but they were not built to support the process of writing formulas.

In "SpreadsheetCoder: Formula Prediction from Semi-structured Context", published at ICML 2021, we describe a new model that learns to automatically generate formulas based on the rich context around a target cell. When a user starts writing a formula with the “=” sign in a target cell, the system generates possible relevant formulas for that cell by learning patterns of formulas in historical spreadsheets. The model uses the data present in neighboring rows and columns of the target cell as well as the header row as context. It does this by first embedding the contextual structure of a spreadsheet table, consisting of neighboring and header cells, and then generates the desired spreadsheet formula using this contextual embedding. The formula is generated as two components: 1) the sequence of operators (e.g., SUM, IF, etc.), and 2) the corresponding ranges on which the operators are applied (e.g., “A2:A10”). The feature based on this model is now generally available to Google Sheets users.

Given the user’s intent to enter a formula in cells B7, C7, and D7, the system automatically infers the most likely formula the user might want to write in those cells.
Given the target cell (D4), the model uses the header and surrounding cell values as context to generate the target formula consisting of the corresponding sequence of operators and range.

Model Architecture
The model uses an encoder-decoder architecture that allows the flexibility to embed multiple types of contextual information (such as that contained in neighboring rows, columns, headers, etc.) in the encoder, which the decoder can use to generate desired formulas. To compute the embedding of the tabular context, it first uses a BERT-based architecture to encode several rows above and below the target cell (together with the header row). The content in each cell includes its data type (such as numeric, string, etc.) and its value, and the cell contents present in the same row are concatenated together into a token sequence to be embedded using the BERT encoder. Similarly, it encodes several columns to the left and to the right of the target cell. Finally, it performs a row-wise and column-wise convolution on the two BERT encoders to compute an aggregated representation of the context.

The decoder uses a long short-term memory (LSTM) architecture to generate the desired target formula as a sequence of tokens by first predicting a formula-sketch (consisting of formula operators without ranges) and then generating the corresponding ranges using cell addresses relative to the target cell. It additionally leverages an attention mechanism to compute attention vectors over the header and cell data, which are concatenated to the LSTM output layer before making the predictions.

The overall architecture of the formula prediction model.

In addition to the data present in neighboring rows and columns, the model also leverages additional information from the high-level sheet structure, such as headers. Using TPUs for model predictions, we ensure low latency on generating formula suggestions and are able to handle more requests on fewer machines.

Leveraging the high-level spreadsheet structure, the model can learn ranges that span thousands of rows.

Results
In the paper, we trained the model on a corpus of spreadsheets created by and shared with Googlers. We split 46k Google Sheets with formulas into 42k for training, 2.3k for validation, and 1.7k for testing. The model achieves a 42.5% top-1 full-formula accuracy, and 57.4% top-1 formula-sketch accuracy, both of which we find high enough to be practically useful in our initial user studies. We perform an ablation study, in which we test several simplifications of the model by removing different components, and find that having row- and column-based context embedding as well as header information is important for models to perform well.

The performance of different ablations of our model with increasing lengths of the target formula.

Conclusion
Our model illustrates the benefits of learning to represent the two-dimensional relational structure of the spreadsheet tables together with high-level structural information, such as table headers, to facilitate formula predictions. There are several exciting research directions, both in terms of designing new model architectures to incorporate more tabular structure as well as extending the model to support more applications such as bug detection and automated chart creation in spreadsheets. We are also looking forward to seeing how users use this feature and learning from feedback for future improvements.

Acknowledgements
We gratefully acknowledge the key contributions of the other team members, including Alexander Burmistrov, Xinyun Chen, Hanjun Dai, Prashant Khurana, Petros Maniatis, Rahul Srinivasan, Charles Sutton, Amanuel Taddesse, Peilun Zhang, and Denny Zhou.

Source: Google AI Blog


View richer information about your coworkers directly in the sidebar for Google Chat, Calendar, Docs, and more.

Quick launch summary 

You can now find and view additional information about people within your organization, your Contacts, and more across additional Google Workspace products. This information includes: 

  • Contact information, such as phone number and email address,  
  • Team and manager, 
  • Office and desk location, 
  • Whether you’ve received email from them before, and more. 

This feature is already available for Gmail, and will now be available from the following products: Google Chat, Calendar, Docs, Sheets, and Slides.

Getting started 

  • Admins: To maximize this feature, it’s helpful to have user data fully populated across Google Workspace apps. Workspace admins can populate this data in a few locations: 
  • End users: There is no end user setting for this feature. Click “Open Detailed View” while hovering over a user’s information card, or select the Contacts icon in the side panel. Visit the Help Center to learn more about using Google products side by side. 

Rollout pace 

Availability 

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

Resources 

View richer information about your coworkers directly in the sidebar for Google Chat, Calendar, Docs, and more.

Quick launch summary 

You can now find and view additional information about people within your organization, your Contacts, and more across additional Google Workspace products. This information includes: 

  • Contact information, such as phone number and email address,  
  • Team and manager, 
  • Office and desk location, 
  • Whether you’ve received email from them before, and more. 

This feature is already available for Gmail, and will now be available from the following products: Google Chat, Calendar, Docs, Sheets, and Slides.

Getting started 

  • Admins: To maximize this feature, it’s helpful to have user data fully populated across Google Workspace apps. Workspace admins can populate this data in a few locations: 
  • End users: There is no end user setting for this feature. Click “Open Detailed View” while hovering over a user’s information card, or select the Contacts icon in the side panel. Visit the Help Center to learn more about using Google products side by side. 

Rollout pace 

Availability 

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

Resources 

View richer information about your coworkers directly in the sidebar for Google Chat, Calendar, Docs, and more.

Quick launch summary 

You can now find and view additional information about people within your organization, your Contacts, and more across additional Google Workspace products. This information includes: 

  • Contact information, such as phone number and email address,  
  • Team and manager, 
  • Office and desk location, 
  • Whether you’ve received email from them before, and more. 

This feature is already available for Gmail, and will now be available from the following products: Google Chat, Calendar, Docs, Sheets, and Slides.

Getting started 

  • Admins: To maximize this feature, it’s helpful to have user data fully populated across Google Workspace apps. Workspace admins can populate this data in a few locations: 
  • End users: There is no end user setting for this feature. Click “Open Detailed View” while hovering over a user’s information card, or select the Contacts icon in the side panel. Visit the Help Center to learn more about using Google products side by side. 

Rollout pace 

Availability 

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

Resources 

View richer information about your coworkers directly in the sidebar for Google Chat, Calendar, Docs, and more.

Quick launch summary 

You can now find and view additional information about people within your organization, your Contacts, and more across additional Google Workspace products. This information includes: 

  • Contact information, such as phone number and email address,  
  • Team and manager, 
  • Office and desk location, 
  • Whether you’ve received email from them before, and more. 

This feature is already available for Gmail, and will now be available from the following products: Google Chat, Calendar, Docs, Sheets, and Slides.

Getting started 

  • Admins: To maximize this feature, it’s helpful to have user data fully populated across Google Workspace apps. Workspace admins can populate this data in a few locations: 
  • End users: There is no end user setting for this feature. Click “Open Detailed View” while hovering over a user’s information card, or select the Contacts icon in the side panel. Visit the Help Center to learn more about using Google products side by side. 

Rollout pace 

Availability 

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

Resources 

View richer information about your coworkers directly in the sidebar for Google Chat, Calendar, Docs, and more.

Quick launch summary 

You can now find and view additional information about people within your organization, your Contacts, and more across additional Google Workspace products. This information includes: 

  • Contact information, such as phone number and email address,  
  • Team and manager, 
  • Office and desk location, 
  • Whether you’ve received email from them before, and more. 

This feature is already available for Gmail, and will now be available from the following products: Google Chat, Calendar, Docs, Sheets, and Slides.

Getting started 

  • Admins: To maximize this feature, it’s helpful to have user data fully populated across Google Workspace apps. Workspace admins can populate this data in a few locations: 
  • End users: There is no end user setting for this feature. Click “Open Detailed View” while hovering over a user’s information card, or select the Contacts icon in the side panel. Visit the Help Center to learn more about using Google products side by side. 

Rollout pace 

Availability 

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

Resources