Tag Archives: Google Sheets

Stay up to date on important changes in your Google Sheets

This announcement was part of Google Cloud Next ‘24. Visit the Workspace Blog to learn more about the next wave of innovations in Workspace, including enhancements to Gemini for Google Workspace.


What’s changing

In order to provide greater visibility into spreadsheet changes most relevant to your workflow and help enable more efficient team communication, we’re introducing conditional notifications. 

These allow you to create rules in spreadsheets that send email notifications when certain criteria are met. When a specific change is made, such as a column value change or a specific range of cell changes, you will receive an email notification with alerts of what occurred in the spreadsheet and who made the update. You also have the option to configure the notifications for others by inputting their email addresses during the notification setup. 

Email notification of changes in a spreadsheet

Who’s impacted 

End users 


Why it matters 

Conditional notifications keep you and your stakeholders up to date on recent changes within a spreadsheet. You can set rules to notify you (or others) when: 
  • Tasks have changed status or owner in a project tracker 
  • Certain items reach a certain number of stock in an inventory tracker 
  • A number drops below a certain value in a forecast analysis 

Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: 
    • If you own or have edit-access to a Sheet, you can set notifications when: 
      • A range of cells changes value 
      • A range of cells matches a particular condition 
    • To set conditional notifications, open your spreadsheet, go to Tools > Conditional notifications > Add rule. You can also right-click directly on a spreadsheet and select Conditional notifications. 
    • Note: The rules are assigned default names automatically. However, you can update the name of the rule by utilizing the text editor. Visit the Help Center to learn how to use conditional notifications.
Adding a rule to set up Conditional notifications in Google Sheets


Rollout pace 


Availability

Available for Google Workspace: 
  • Business Standard, Plus 
  • Enterprise Starter, Standard, Plus 
  • Education Plus 
  • Enterprise Essentials 

Resources 


Now generally available: Edit client-side encrypted Excel files in Google Sheets

What’s changing 

Last year, we announced in beta the ability to view and edit client-side encrypted Excel files with Google Sheets. Starting today, we’re rolling it out in general availability for select customers.



Additional details

With this release:
  • You can only view and edit .xslx Excel file types — additional Excel and tabular file types are not supported.
  • The maximum supported file size is 100MB.
  • The maximum number of cells that can be opened is 10 million.

As we continue to improve Office editing in encrypted Google Sheets, you may encounter incompatibilities for certain features. Some features are not displayed and/or editable, but will be preserved in the document and viewable in Microsoft Office. Other features may be lost or altered in the latest version of the file when it is edited in Google Sheets. You will see a notification within the document if editing will cause any features to be lost or altered.


Getting started


Rollout pace


Availability


Available for Google Workspace:
  • Enterprise Plus
  • Education Standard and Plus

Resources


Google Workspace Updates Weekly Recap – May 24, 2024

2 New updates

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


Expanding row limits in Connected Sheets for BigQuery 
Last year, we increased the maximum number of rows of results returned from BigQuery to 50,000 for pivot tables and data extracts. This week, we’re excited to announce this has been expanded to 100,000 rows for pivot tables and 500,000 rows for extracts (with a cell limit of 5 million). This will allow you to analyze even more results in Sheets from the petabytes of data in BigQuery. | Rolling out to Rapid Release and Scheduled Release domains now. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Learn more about analyzing & refreshing BigQuery data in Google Sheets using Connected Sheets, Google Sheets limitations, and getting started with BigQuery data in Google Sheets.

Custom text fields are now available for eSignature in Google Docs and Google Drive 
You can now input custom text fields when using eSignature. This gives you the flexibility to collect specific information as needed, including a phone number, job title, company name, and more. | Available to Google Workspace Individual users and other eligible Google Workspace customers who are on the eSignature alpha. | Rolling out to Rapid Release domains and Scheduled Release domains now. | Learn more about sending signature requests & signing documents with eSignature.




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.


Filter, sort, and display your Google Meet hardware devices by product service status 
You can currently filter, sort, and display your Google Meet hardware devices by whether they are online, offline, or experiencing an application load-failure. This week, we’re expanding these parameters to include whether the Calendar and Jamboard services are turned OFF. | Learn more about filtering, sorting and displaying Meet hardware devices. 

Introducing adaptive audio in Google Meet: creating ad-hoc meeting spaces with multiple laptops 
With “adaptive audio,” you and your team can join Google Meet using multiple laptops in close proximity without awkward echos and audio feedback. | Learn more about adaptive audio in Google Meet. 

Send emails to spaces in Google Chat 
After a space manager generates an email address for a space, members (or anyone in your domain with the email address) can send or forward any email to that space. This provides a great way for teams to easily triage or discuss email content with stakeholders within the space. The email will appear as a clickable card showing a snippet of the email in the designated space. | Learn more about sending emails to spaces. 

Manage spaces at scale with new Chat API functionality 
We are pleased to announce the launch for additional features of Chat API via the Developer Preview Program, enabling space management at scale on behalf of admin users. These new features are available to all users currently enrolled in the Developer Preview Program. | Learn more about new Chat API functionality. 

Introducing Gemini offerings for Google Workspace for Education customers 
Beginning May 23, 2024, Google for Education customers will be able to leverage new and powerful ways of working, teaching and learning with Gemini for Google Workspace with two new paid add-ons. | Learn more about Gemini Education and Gemini Education Premium add-ons.

Expanding voice typing and automatic captions to additional browsers 
We’re expanding support for voice typing and captions features to additional browsers, such as Edge and Safari. When a user turns on voice typing or captions, the web browser controls the speech-to-text service, determines how speech is processed, and then sends text data to Google Docs and Google Slides. | Learn more about voice typing features in additional browsers.



Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.


Rapid Release Domains: 

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

New ways to quickly format and organize data with Tables in Google Sheets

This announcement was part of Google Cloud Next ‘24. Visit the Workspace Blog to learn more about the next wave of innovations in Workspace, including enhancements to Gemini for Google Workspace.


What’s changing

We know it can be time consuming to perform repetitive tasks like updating data in a spreadsheet. In addition, maintaining the structure and format of the data can be difficult when there are multiple people updating the document.

To help solve for this, we’re excited to announce tables in Google Sheets. With tables, you can simplify and accelerate spreadsheet building by bringing format and structure to unorganized ranges. By selecting your data range and going to Format > Convert to table, Sheets now does the heavy lifting to format and organize data with a polished design including column types, filters, color coding, dropdown menus and more. 
Convert to table in Google Sheets
Here’s how using tables reduces the time you would usually spend manually formatting data: 
  • Auto-applied formatting: When you convert your data to a table, Sheets automatically applies formatting to polish your data so that all inputs are properly aligned, reducing the need for manual changes. You can further customize your table by changing colors, readjusting the row height, and more. 
  • Column types: For each column, you can set the appropriate column type (e.g., date, currency, dropdown), and your table will make sure all entered data has the right formatting based on the column type. Data entered that does not align with a set column type will result in a warning. 
  • Unified menu: Above the table, you will see a menu option to manage table-level settings (e.g., adjust table range) and take action (e.g., create a filter view for your table). 
  • Table references: Table references are a special way to refer to a table or parts of a table in a formula. When you convert your data to a table, Sheets provides a name for the table and each column header. When you reference table elements by name, the references update whenever you add or remove data from the table. For example: Instead of explicit cell references: =COUNTIF(B2:B10, “P0”), you can use table references: =COUNTIF(Task_tracker[Priority], “P0”). 
When you are using tables, you’ll also have access to our new type of view, group by, where you can aggregate your data into groups based on a selected column. For instance, you can decide to group all data at the same priority level in one place, as shown below.
Group by view in Tables in Google Sheets
We’re also introducing pre-built tables that you can populate with common data types for everyday tasks like project management, inventory management, event planning and more. Now with pre-built tables, you never have to build a spreadsheet from scratch again. 
Pre-built tables in Sheets

Who’s impacted

End users 


Why it matters 

Tables will transform the way teams organize their data, simplify data creation, and reduce the repetitive tasks needed to format, input, and update data. They also allow teams to confidently share data widely while maintaining its integrity and consistency. 

Tables are well suited for tracking and organizing information such as project tracking, event planning, and inventory management. 

Getting started 

Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 8, 2024, with expected completion by May 30, 2024 
  • Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on June 6, 2024 

Availability 

  • Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts 

Resources 

Easily convert data to dropdown chips in Google Sheets

What’s changing

In March, we introduced the ability to insert preset dropdown chips that are configured for common use cases like priority or review statuses in Google Sheets. Today, we’re adding a new feature that helps you quickly convert ranges of data into dropdown chips in bulk. 

If you have a column of data that includes a variety of data values (e.g., different project statuses like on track, paused, completed), Sheets will show a “Convert to dropdown chips” suggestion when you click into your data range. By hovering over that indicator, you can preview the suggestion and then convert to dropdown chips in one click. 
Easily convert data to dropdown chips in Google Sheets


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: 
    • To insert dropdown chips on your own, type “@” followed by “dropdown
    • To turn off this feature, go to Tools > Suggestion controls > (deselect) Enable dropdown chip suggestions. 
    • Visit the Help Center to learn more about inserting smart chips in your Google Sheets.

Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 7, 2024, with expected completion by May 30, 2024
  • Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 30, 2024 

Availability 

  • Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts 

Resources 

Google Workspace Updates Weekly Recap – April 26, 2024

3 New updates

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


Customizable Home tab for Google Chat apps 
Recently, we announced the availability of the "Home" tab for Google Chat apps through the Google Workspace Developer Preview Program. This feature allows developers to create a new tab in their Chat apps, known as “App Home”. App home can be customized to display user-specific dashboards, a list of open items and tasks, and more. We’re excited to announce this is now generally available for Google Workspace developers. | Rollout to Rapid Release domains and Scheduled Release domains is complete. | Available to all Google Workspace customers. | Learn more about sending an app home card message for a Google Chat app.
Customizable Home tab for Google Chat apps

Create Looker Studio reports from Google Sheets 
Looker Studio enables users to quickly build interactive reports and dashboards, and starting today they can now be created directly from Google Sheets. More specifically, users can: 
  • Pick which sheet or cell range to use in the generated report on Looker Studio. 
  • Transform the data in Sheets to an automatically generated Looker Studio report in a single click, and save and share the report with an individual or a team. 
The Looker Studio report remains connected to the Sheet, and can be refreshed to reflect data updates. | Rolling out to Rapid Release domains and Scheduled Release domains now. | Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn how to create a Looker Studio report from Google Sheets

Create Looker Studio reports from Google Sheets

Export Gemini data for users in your organization 
Super admins can now export all of their users Gemini data, including prompts and Gemini’s responses to those prompts. Expanding takeout to include Gemini data continues to ensure that our customers have control over their organization’s data in order to manage their data privacy and compliance needs. | Rollout to Rapid Release domains and Scheduled Release domains is complete. | Available to Google Workspace customers with the Gemini Enterprise and Gemini Business add-on, as well as those customers with Gemini (gemini.google.com) enabled for their users. | Learn more about exporting Gemini data, exporting all of your organization’s data, and exporting data by organizational unit, group, or user. Additionally, you can use the Help Center to learn more about allowing your users to download their data.





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.


External participants can now join Google Meet client-side encrypted calls 
We’re enhancing the experience for client-side encrypted Google Meet calls to include support for inviting external participants, including users without a Google account. | Learn more about external participants joining CSE Meet calls. 


Client-side encryption can now be selected as a data loss prevention condition 
You can now use client-side encryption as a condition for a data loss prevention (DLP) rule. | Learn more about the DLP rule. 


Seamlessly transfer between devices during a Google Meet call 
You can now smoothly transfer between devices while on a Google Meet call without hanging up and rejoining. | Learn more about transferring between devices during a Google Meet call. 


Import data from Slack to Google Chat using CloudFuze 
With the CloudFuze integration, you can move messages and memberships from Slack channels into Chat spaces. CloudFuze also imports data while maintaining historical timestamps to ensure users can start using spaces right where they left off. | Learn more about Google Chat and CloudFuze.


Get notified about application load failures for your Google Meet Hardware devices 
You can now opt-in to receive email or text message notifications when application load failures occur. Subscribing to alerts can help you stay on-top of what’s happening across your hardware fleet and quickly take action to resolve these issues. | Learn more about application load failure notifications.


Workspace Data Protection rules are now available for Gmail in Beta
Launching first to beta, we’re introducing data loss prevention rules for Gmail. Data protection rules help admins and security experts build a stronger framework around sensitive data to prevent personal or proprietary information from ending up in the wrong hands. | Learn more about Data Protection rules.



Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.


Rapid Release Domains: 
Scheduled Release Domains: 
Rapid and Scheduled Release Domains: 

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 – March 22, 2024

2 New updates

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


Search for files directly using new search bar in Google Drive
Last year, we introduced a new homepage view in Google Drive that makes it easier and faster for you to find files that matter most. Starting this week, you’ll notice an expanded search bar and enhanced search chip capabilities that enable you to filter files across your entire Drive. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 15, 2024. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about how to use Google Drive 
Search for files directly from the new homepage view in Google Drive



Improving filtering for merged cells in Google Sheets 
We’re excited to announce that users can now filter ranges with merged cells in Google Sheets. 
  • For ranges with vertical merges, users can create a filter and apply various filter types (condition, values, and color). 
  • For ranges with horizontal merges, users can create a filter, apply various filter types (condition, values, and color), and sort by values or color. 
Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 3, 2024. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about sorting & filtering your data.


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.



The current appointment slots feature in Google Calendar will be replaced by appointment schedules in July 2024 
To create a cohesive user experience in Calendar, as of July 18, 2024, the appointment slots feature will be replaced by appointment schedules. | Appointment schedules are available to Google Workspace Business Starter, Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, Nonprofits, Google Workspace Individual customers and Google One Premium users only. | Learn more about appointment scheduling.


Securely migrate existing encrypted messages to Gmail client-side encryption (CSE) 
Beginning this week, admins can migrate encrypted emails from other services like Microsoft 365, Microsoft Exchange, or Virtu, to Gmail client-side encryption in the S/MIME format. This enables Google Workspace customers to simplify the migration process by bulk importing sensitive emails as S/MIME messages without compromising their privacy or compliance posture. | Available to Google Workspace Enterprise Plus, Education Standard, and Education Plus customers. | Learn more about securely migrating existing encrypted messages to Gmail CSE.


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

 





Set up dropdown chips more easily in Google Sheets

What’s changing

In 2022, we announced the ability to create dropdown chips in Google Sheets. This custom formatting smart canvas feature enables you to easily indicate statuses or various project milestones within your spreadsheet. 

Today, we’re building upon this by introducing preset dropdowns. Instead of manually creating values for your dropdowns, you can insert preset dropdown chips that are configured for common use cases like priority or review statuses. After inserting a preset dropdown, you can use the data validation sidebar to easily adjust the options or add styles. 
Set up dropdown chips more easily in Google Sheets


Getting started 


Rollout pace 


Availability 

  • Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google account 

Resources

Smooth scrolling in Google Sheets now available on desktop

What’s changing

We’re excited to announce a highly-requested feature that improves control over your scrolling experience in Google Sheets. With smooth scrolling, you can scroll to a specific part of a row or column and stop wherever you’d like within the spreadsheet. 

This update works with all Sheets features, such as frozen rows, hidden columns, charts, buttons, comments, on right-to-left layouts, and when you use scrollbars (instead of a mouse/trackpad). 
smooth scrolling in Sheets


Getting started 

  • Admins: There is no admin control for this feature. 
  • End users: Use a trackpad, mouse or the scrollbar to access this update in new and existing spreadsheets. 

Rollout pace 

Availability 

  • Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts

Google Workspace Updates Weekly Recap – March 1, 2024

3 New updates

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


Playback improvements to videos uploaded on Google Drive 
We’re enabling the generation and playback of Dynamic Adaptive Streaming over HTTP (DASH) video transcodes for all new videos uploaded to Google Drive. DASH transcodes provide adaptive bitrate playback, which allows users to receive higher or lower resolution playback based on aspects like their local network quality. As a result of this change, you’ll also notice: 
  • Improvements in join time (the time it takes from clicking play to actually starting playback) 
  • A reduction in re-buffering, both in normal playback as well as during playback at higher speeds 
While this feature applies to all new videos uploaded to Drive, existing videos in Drive will be updated by the end of the year. | Rolling out to Rapid Release domains and Scheduled Release domains now. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. 


Enhancing search within the Google Drive app 
We’re improving Google Drive’s search experience on iOS devices (with Android coming soon) by: 
  • Simplifying how you access query filters by introducing filter categories that are accessible directly below the search bar and include filters for File Type, Owners and Last modified. 
  • Showing you relevant query filters as you type your query, enabling you to easily select a filter and saving you the time and effort of typing out the full search. 
  • Adding the option to further refine your search after reaching the search results page. 
These updates are available now to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts using iOS devices. | We will provide an update when this is available on Android devices. | Learn more about finding files in Google Drive



Further extending long running queries within Connected Sheets 
Last year, we extended the timeout time from 5 minutes to 10 minutes for BigQuery and Looker. Now, the timeout time has increased to 20-30 minutes, and starting this week Connected Sheet users can view the status of a query and easily cancel it on Google Sheets. In addition to the ability to analyze data from queries that scan even larger data sets in Sheets, we hope these increased user controls give you even more oversight, especially in cases where queries might be taking a while to complete. | Rolling out to Rapid Release domains and Scheduled Release domains now. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about Connected Sheets for Looker and Analyze & refresh BigQuery data in Google Sheets using Connected Sheets.


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.



Now generally available: Import and convert sensitive Excel files into client-side encrypted Google Sheets 
You can now import and convert sensitive Excel files into Google Sheets with client-side encryption. | Available to Google Workspace Enterprise Plus, Education Plus, and Education Standard customers only. | Learn more about working with encrypted files in Sheets. 

Easily identify which unread threads are most relevant to you in Google Chat 
With multiple threads across numerous spaces, we know it can be difficult to identify which unread threads are most relevant to you. In order to provide you with more context upfront, you will now see participant avatars for unread threads in the conversation view. Without having to click to open the thread side panel, it will now be much easier to decide which threads to read and reply to. | Learn more about participant avatars for unread threads in Chat. 

Available in open beta: the Groups Admin role can now be provisioned for specific group types 
The Groups Admin role can now be assigned for security groups or non-security groups. Previously, those with the Groups Admin role had access to all groups within an organization. This change gives administrators more granular delegation of group admin responsibilities, helping limit access to the most sensitive groups to only those who absolutely need it. | Learn more about the beta for the Groups Admin role. 

New ways to annotate Google Docs 
We’re excited to announce a new feature, markups in Google Docs, which gives you more flexibility when providing feedback in a document. The new markups experience lets you add handwritten annotations to documents with a stylus or your finger when using an Android device. | Learn more about markups in Docs. 

Conduct direct 1:1 calls with people outside your video calling network on Google Meet mobile 
Earlier this year, we introduced cloud-encrypted 1:1 video calls between users in the same domain using the Meet mobile app. In the coming weeks, users from outside of your domain will be able to initiate 1:1 video calls with your users and vice versa. Admins will be able to pre-configure this functionality as on or off for their users with a new admin control. | Learn more about 1:1 calling using Google Meet mobile. 

Easily manage and secure your school’s accounts and mobile devices centrally in Google Admin console with the Endpoint Education Upgrade 
This year, we announced Endpoint Education Upgrade, which adds enterprise endpoint management features to your Google Workspace for Education edition. Using endpoint management, admins can better manage and secure the phones and tablets used across their school directly from the Admin console. | Available to Education Standard and Education Plus only. | Learn more about the Endpoint Education Upgrade. 

Set client-side encryption as the default mode for new emails, events, and files on mobile 
Admins can now set client-side encryption (CSE) to be on by default on Android and iOS for: newly drafted Gmail messages and replies, newly created Google Calendar events, and newly uploaded Google Drive files. | Available to Workspace Enterprise Plus customers only. | Learn more about client-side encryption default mode.


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.


Rapid Release Domains: 
Scheduled Release Domains: 
Rapid and Scheduled Release Domains: 

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