Tag Archives: Google Sheets

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



Ability to create announcement spaces using the Google Chat API is now generally available 
In June, we introduced the option to create announcement spaces using the Google Chat API through the Google Workspace Developer Preview Program. We’re excited to announce Google Workspace developers can now use the Chat API to create announcement spaces, plus read and update the permission settings of a space. | Rolling out now to Rapid Release domains and Scheduled Release domains. | Available to all Google Workspace customers. | Visit these Developer Docs for more information: PredefinedPermissionSettings and PermissionSettings fields.


Additional improvements to tables in Google Sheets 
Following our announcement of improvements to tables in Google Sheets, we’re adding even more enhancements to the experience. More specifically, you can now: 

1. Insert a blank table from the pre-built table sidebar 
Insert a blank table from the pre-built table sidebar

2. Reference tables successfully via IMPORTRANGE. For example, if you had a table named Table1 with column header values of of Column 1, Column 2, Column 3, etc.: 
    • To import the table range, including header cells, you would input: =IMPORTRANGE(spreadsheet_url, “Table1[#ALL]”) 
    • To import only the footers of the table range, you would input: =IMPORTRANGE(spreadsheet_url, “Table1[“#TOTALS]”) 
    • To import the table range, excluding header cells, you would input: =IMPORTRANGE(spreadsheet_url, “Table1[“#DATA]”) 
    • To import the first two columns of the table range, including header cells, you would input: =IMPORTRANGE(spreadsheet_url, “Table1[[Column 1]:[Column 2],[#ALL]]”) 
3. Use the following keyboard shortcuts to easily convert ranges to tables: 
  • Cmd+Opt+T for Mac 
  • Ctrl+Alt+T for Linux and Windows 
    Rollout to Rapid Release and Scheduled Release domains for #1 is complete. | Rolling out to Rapid Release domains now for #2 and #3; launch to Scheduled Release domains planned for September 26, 2024 for #3 and October 3, 2024 for #2. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Visit the Help Center to learn more about using tables in Google Sheets.


    Introducing Dual Screen on Meet
    Following the recent announcement of an improved user experience for Google Meet on Android devices, we’re excited to introduce an additional feature, available on the Pixel 9 Pro Fold device, that provides you with a more immersive video call experience. Through the use of the front and inner cameras, you can now show both yourself and what you're looking at at the same time. Additionally, the person you're video chatting with can be seen on both the inner and outer screens to include everyone around you in the call. | Rollout to Rapid Release domains is complete; rolling out now to Scheduled Release domains. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Visit the Help Center to learn how Dual Screen on Google Meet works.

    Use both screens during a Meet call - rear screen view of foldable

    Use both screens during a Meet call - rear screen view of foldable


    Use both screens during a Meet call - front screen view of foldable



    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.


    Adding multi-monitor support to Google Slides
    We’re making it easier to view your Google Slides presentation controls on your computer while presenting to an audience using a connected external monitor or projector. | Learn more about multi-monitor support in Slides. 

    New beta available that restricts access to folders in Google Drive 
    We’ve introduced a beta that allows shared drive managers to restrict folders to specific users within a shared drive. This provides shared drive managers with greater flexibility to keep relevant content within a single shared drive, while restricting access to shared folders with sensitive information. | Learn more about restricting folder access.

    New design and accessibility improvements for embedded Google Calendars 
    Starting this week, you’ll notice a refreshed look and feel for embedded calendars that is in line with Google Material Design 3 and now includes enhanced accessibility features, such as the ability to use an embedded calendar with a screen reader and keyboard shortcuts to navigate more easily, and more. | Learn more about embedded Google Calendars.

    NotebookLM now available as an Additional Service 
    Last year, we introduced an Early Access App called NotebookLM, an experimental product using some of Google's most advanced models, like Gemini 1.5 Pro, that helps you gain critical insights grounded in the content of source documents you trust. We’re excited to announce that NotebookLM is officially available as an Additional Service. | Learn more about NotebookLM

    Admin features for space management via the Chat API are now generally available 
    Earlier this year, we introduced a series of space management capabilities for Workspace admins in the Google Chat API via the Google Workspace Developer Preview Program. These API features are now generally available for all Google Workspace customers and developers. | Learn more about space management via the Chat API. 

    Create birthdays in Google Calendar 
    To ensure a birthday is never missed, we’re introducing the ability to create and modify birthday events in Google Calendar on Android devices. | Learn more about birthdays in Calendar. 

    Additional iOS data exfiltration enhancement: account level data sharing between Google Workspace apps and non-Google Workspace apps on or off 
    Admins can now enable content sharing on personal Workspace accounts while preventing data sharing from corporate Workspace accounts on iOS devices. | Learn more about iOS data exfiltration enhancements.


    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 – September 13, 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.



    Co-annotate from select Google Meet hardware devices
    We’re expanding annotation capabilities in Meet to include select Google Meet hardware devices. These devices can be appointed co-annotators by presenters and you can use annotation tools such as a pen, sticker and more directly from the touchscreen of the device. | Rollout to Rapid Release and Scheduled Release domains is complete. | Available to Google Workspace Business Starter, Standard, and Plus; Enterprise Starter, Standard, and Plus; Frontline Starter and Standard; Essentials, Enterprise Essentials, and Enterprise Essentials Plus; Education Standard, Plus, the Teaching & Learning Upgrade; Workspace Individual subscribers. | Visit the Help Center to learn more about using annotations in Google Meet.


    New advancements in Connected Sheets for Looker 
    Last year, we introduced Connected Sheets for all Looker-hosted instances, enabling users to analyze data using pivot tables, charts, formulas, and other integrated data sources. This week, we’re excited to announce the ability to directly link Connected Sheets to existing Looker queries, rather than having to start from scratch in Sheets by connecting to an Explore every time. This highly-requested feature is especially useful for Looks, a special type of query that’s been saved in the Looker UI, and whose definition can be updated over time if needed. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Admins should use the Looker's Admin menu to make sure Connected Sheets for Looker is enabled. End users can visit the Help Center to learn more about using Connected Sheets in your organization.


    TeamViewer Add-on for for Google Meet now supports remote desktop 
    A TeamViewer add-on for Google Meet is now available in the Google Workspace Marketplace, allowing Meet to tap into a leading remote connectivity platform. You can now rely on Meet + TeamViewer to enable remote support (e.g., IT support desk) that's easy, secure and reliable for your business. | Rollout to Rapid Release and Scheduled Release domains is complete. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Admins can visit the Help Center to learn more about managing Marketplace apps on your allowlist or installing Marketplace apps in your domain. End users can view the TeamViewer Remote Control listing, learn more about the offering on TeamViewer’s website, and use the Help Center to learn more about using add-ons with Google Meet. 
    TeamViewer launched as a featured Meet add-on to enable remote IT support



    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.


    Gemini reports now include user-level usage, including app usage insights 
    We’re incorporating additional data in Gemini reports to help our customers gain a deeper understanding of Gemini usage and adoption across their organizations. Gemini reports now include user and app level Gemini usage and adoption data based on the last 28 days of usage. | Learn more about Gemini reports. 

    Access and sort shared files more easily in Google Chat conversations
    The Shared tab is now available in 1:1 direct messages and group messages, enabling easier collaboration across all conversation types. | Learn more about the shared tab in Chat. 

    Google Cloud Directory Sync now complies with your conflicting accounts management settings 
    When Google Cloud Directory Sync (GCDS) attempts to create new users, it may encounter unmanaged accounts that conflict with the accounts it’s attempting to create. In these instances, GCDS will now comply with the conflicting accounts management settings specified in the Admin console. | Learn more about Google Cloud Directory Sync. 

    Google Meet Add-ons SDK is now generally available
    The Meet Add-ons SDK is now generally available for the web, which allows developers to iframe their app into Meet, and lets meeting participants interact with the app’s content directly inside the Meet canvas. | Learn more about Meet Add-ons SDK.

    Improving the Google Workspace Marketplace app publishing experience with Drafts 
    Developers can now make changes to their app listing, save them as a draft, and send the draft version to review. | Learn more about app list drafts. 


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

    Upload additional types of documents to Gemini (gemini.google.com) for insights and analysis

    What’s changing 

    Beginning today, Google Workspace users with a Gemini Business, Enterprise, Education or Education Premium license can now upload a variety of files from Google Drive or locally from your device into Gemini (gemini.google.com): 
    • Document and text files, such as TXT, DOC, DOCX, PDF, RTF, DOT, DOTX, HWP, HWPX and Google Docs 
    • Data Files, such as XLS, XLSX, CSV, TSV and Google Sheets 
    Gemini can use uploaded files to gain context and analyze your content. In turn, this can help enhance your understanding, research, and writing through summarization of complex subject matter, identification of trends and insights, and recommendations for improving writing and document organization. Uploading a document can also help give you more personalized and relevant responses. 
    Gemini document uploads


    Additional details 

    • At this time, Context-Aware Access (CAA) for files uploaded from Google Drive isn’t supported. Context-Aware Access gives you control over which apps a user can access based on their context, such as whether their device complies with your IT policy. Learn more about Context-Aware Access.
    • Uploading files from Google Drive honors access control settings for files within Drive, meaning users can only upload files that they own or have been shared with them. 
    • File upload is not available to Google Workspace users accessing Gemini as an additional Google service.
    • Users with a Gemini for Google Workspace license who access Gemini as a core service are subject to the Google Workspace Terms of Service or Google Workspace for Education Terms of Service (for education institutions). When users use Gemini as a core service, their chats and uploaded files won't be reviewed by human reviews or otherwise used to improve generative AI models. 

    Getting started 

    Rollout pace 

    Availability

    Available for Google Workspace customers with 
    • Gemini Business, Enterprise, Education, Education Premium add-on 

    Resources 

    View and structure Google Form data as a table in Google Sheets

    What’s changing

    We're introducing a new feature that enables users to more easily view and structure their Google Form data in Sheets. 

    Starting today, when a user initiates the creation of a new sheet using their Forms data, Sheets will automatically open the data as a table, bringing format and structure to your data. If a user opens a pre-existing sheet connected to a Form, there will be no change and the user will need to convert the data to a table by going to Format > Convert to table. 

    View and structure Google Form data as a table in Google Sheets


    Getting started

    • Admins: There is no admin control for this feature. 
    • End users: 
      • For pre-existing spreadsheets connected to Form data, you can convert the data to a table manually by selecting the data range and going to Format > Convert to table. 
      • Visit the Help Center to learn more about using tables in Google Sheets. 

    Rollout pace 

    • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on August 15, 2024 
    • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on September 5, 2024 

    Availability

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

    Resources 

    Use intelligent suggestions for table conversion in Google Sheets

    What’s changing

    Following the introduction of tables in Google Sheets and the recently announced improvements to tables, we’re excited to support a new automated way for users to transform their data into a well-formatted table, with rich data types.

    If you have a meaningful range of data, Sheets will show a “Convert to table” suggestion when you click into your data range. By hovering over that indicator, you can preview the suggestion and then convert your range to a table in one click. 
    suggestions for table conversion in Google Sheets

    Who’s impacted

    End users 


    Why you’d use it 

    This update encourages the use of tables, a feature that enables users to transform the way they organize their data, simplify data creation, and reduce the repetitive tasks needed to format, input, and update data in Sheets. 


    Getting started 

    • Admins: There is no admin control for this feature. 
    • End users: 
      • This feature will be on by default and can be disabled by going to Tools > Suggestion controls > (deselect) Enable table suggestions. 
      • While the suggestion to convert to table will likely appear automatically, you can also convert data to a table manually by selecting a data range and going to Format > Convert to table. 
      • Visit the Help Center to learn more about using tables in Google Sheets. 

    Rollout pace 

    • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on August 13, 2024 
    • Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 4, 2024 

    Availability 

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

    Resources 

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


    More granular control for Google Apps Script
    We’re introducing a new toggle in the Admin console that adds controls for who can access and execute Google Apps Script scripts.
    • Users who have Apps Script turned on can use it to create, edit, and execute Apps Script scripts.
    • When disabled, end users can’t create or edit scripts and script and trigger executions are blocked. 
    By default, Apps Script is turned on for all users in an organization. To change this setting, navigate to the Admin console > Apps > Google Workspace > Drive and Docs > Google Apps Script. This setting will not take effect if the entire Drive and Docs Service is turned OFF.  | Rolling out now to Rapid Release and Scheduled Release domains. | Available to Google Workspace customers. | Learn more about turning Apps Script on or off for users.


    Improving tables in Google Sheets
    Following our announcement of tables in Google Sheets, we’re excited to introduce improvements to the experience. More specifically, you can now: 

    1. Add table rows (anywhere in a table) and columns (to the right of a table) from an easy button at the edge of a table. 
    Add table rows and columns from an easy button at the edge of a table.

    2. Automatically set column types when converting a range to a table.
    Automatically set column types when converting a range to a table

    3. Drag values down or across to auto-fill cells, which expands the table automatically.

    Drag values down or across to auto-fill cells, which expands the table automatically.

    4. Use spaces in table names, meaning you can name something “Project tracker” instead of “Project_tracker”.

    Use spaces in table names
    Rollout to Rapid Release domains for #2 is complete; launch to Scheduled Release domains planned for August 5, 2024. | Rolling out to Rapid Release domains now for #1, #3 and #4; launch to Scheduled Release domains planned for August 14, 2024. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Visit the Help Center to learn more about using tables in Google Sheets. 

    Google Meet annotation updates for mobile devices 
    Earlier this year, we announced annotations for Google Meet, which made it possible for presenters and their appointed co-annotators to highlight content or make other notations over presented content. Beginning today, Android users can appoint co-annotators. Previously on Android devices, it was only possible for presenters to use annotations. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to Google Workspace Business Starter, Standard, and Plus; Enterprise Starter, Standard, and Plus; Frontline Starter and Standard; Essentials, Enterprise Essentials, and Enterprise Essentials Plus; Education Standard, Plus, the Teaching & Learning Upgrade; Workspace Individual subscribers. | Visit the Help Center to learn more about using annotations in Google Meet.


    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.


    Catch up on followed threads from the home shortcut in Google Chat 
    We’re introducing the ability to follow and review threads within the home shortcut in Chat. | Learn more about threads in home. 

    Gemini in the side panel of Google Drive introduces a new PDF viewing experience 
    You can now interact with the Gemini side panel while viewing PDFs. | Learn more about PDF viewing with Gemini. 

    Allowlist and Audit Logs for URLs accessed from Google Apps Script and Google Sheets 
    Admins can now monitor which URLs are being accessed by referencing new logs that we’re adding to the audit and investigation page. Admins can then create an allowlist that controls which of those URLs they’d like to enable/disable. | Learn more about accessed URLs. 

    Prevent downloading, printing, or copying files by combining Data Loss Prevention rules with Context-Aware Access conditions 
    Today, we’re expanding protections by enabling admins to combine DLP rules with Context-Aware Access conditions. | Learn more about combining rules and conditions.

    Admins can now centrally set default grading settings for teachers in their district
    Classroom admins can now centrally set default grading settings for teachers in their district using the Admin console. | Learn more about default grading settings.

    Educators can now create new classes in Google Classroom using SIS data and import grading periods from the SIS
    Teachers can now create new classes by importing information such as student rosters, co-teachers, grading categories, and grading periods from their SIS. Also, teachers can now import their grading periods from their student information systems (SIS) into Classroom. | Learn more about new SIS capabilities. 


    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: 

    Paused rollouts

    We have paused the rollout for this feature while we evaluate performance and quality. We will provide an update with new rollout information as soon as possible. 

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


    Allowlist and Audit Logs for URLs accessed from Google Apps Script and Google Sheets

    What’s changing

    We’re introducing a feature that will allow admins to restrict which URLs Apps Scripts and Sheets can source external content from. More specifically, admins can now monitor which URLs are being accessed by referencing new logs that we’re adding to the audit and investigation page. Admins can then create an allowlist that controls which of those URLs they’d like to enable/disable. 


    When such an allowlist is specified, users in the organization will only be able to use those allowlisted URLs for both their Apps Scripts and their Sheets IMPORT functions. This allows organizations to more granularly control access in a way that better aligns with a Zero Trust security posture. 


    Who’s impacted 

    Admins and end users 


    Why it’s important 

    Data exfiltration is an important security concern for admins, especially when it comes to Apps Scripts and Sheets because certain functions are capable of accessing external data. With this update, admins have more granular control over URLs accessed by users in their organization. 


    Getting started 

    • Admins: 
      • Logs can be found under Reporting > Audit and investigation > Drive Log Events OR Security > Security Center > Investigation Tool. 
      • The URL allowlists can be found in the Admin console under Apps > Google Workspace > Drive and Docs > Features and Applications > Importing and fetching from URLs. 
        • If an allowlist is not established, no URLs will be restricted. 
      • Visit the Help Center to learn more about Drive log events. 
    • End users: There is no end user setting for this feature. 

    Rollout pace 

    Availability 

    • Available to all Google Workspace customers 

    Resources

    Google Workspace Updates Weekly Recap – July 26, 2024

    1 New update

    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.

    Allow dropdown chips to have multiple selections in Google Sheets
    Previously, dropdowns could only have one value selected in Google Sheets. Starting this week, we’re introducing the ability to allow for multiple selections within a dropdown. This functionality is useful in scenarios when multiple project milestones, statuses, or teams are applicable for one item. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for August 12, 2024. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Learn more about inserting dropdown chips in Google Sheets. 
    Allow dropdown chips to have multiple selections in Google 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.


    Google Drive inventory reporting is now available in open beta 
    Google Drive inventory reporting is now available in open beta, providing admins with enhanced visibility into the state of their data assets. | Learn more about Drive inventory reporting. 

    Reduce live-stream bandwidth consumption to a fraction of the traffic volume with eCDN for Google Meet 
    In September 2023, we introduced ultra-low latency livestreaming and since then we’ve introduced several improvements for the overall experience. This week, we’re excited to introduce the latest enhancement for ultra-low latency live streaming: Enterprise Content Delivery Network (eCDN) support for Google Meet. | Learn more about reducing live-stream bandwidth. 

    Adding Data Loss Prevention (DLP) to form content in Google Forms 
    We’re continually investing in data protection capabilities for Google Forms. We’ve already enabled data loss prevention (DLP) for Google Drive policies that apply to files submitted in external Forms, including Forms from external organizations. To expand on this, we’re announcing that DLP policies for form content in Google Forms is now generally available. | Learn more about DLP with Forms. 

    Enable Classification labels on specific Google Workspace applications
    To improve granularity in enabling & governing labels, we are replacing and improving the existing “Labels” setting within Apps > Google Workspace > Drive & Docs and adding label-level application toggles to the Label Manager tool. | Learn more about classification labels on Workspace apps. 

    Introducing Google Meet LTI™ 
    To help improve remote and hybrid learning, we’re introducing Google Meet LTI™ for Canvas by Instructure and PowerSchool Schoology Learning. This builds on the existing Google Workspace Learning Interoperability Tools including Assignments LTI™ and Google Drive LTI™. | Learn more about Meet LTI™ 

    Improved collaboration with Google Workspace LTI™ integrations in PowerSchool Schoology Learning 
    In order to bring the collaborative power of Google Workspace for Education to even more partners, we’re excited to announce updated Google Workspace LTI™ integrations in Schoology. | Learn more about Workspace LTI™ integration in PowerSchool Schoology.

    Automatically generated captions for videos in Google Drive 
    Starting this week, when you upload a video to Google Drive, captions for the video can be automatically generated. | Learn more about generated captions for Drive videos. 

    Label administration is becoming more discoverable and flexible in the Admin console 
    We’re introducing several changes to make labels more discoverable and flexible for organizations. | Learn more about labels in the Admin console.

    AI Classification in Google Drive is now available for the Gemini Education Premium add-on
    We’re expanding the availability of AI Classification in Google Drive to Google Workspace for Education customers with the Gemini Education Premium add-on. | Learn more about AI Classification in Drive.

    Enhancing your productivity on Android devices with new features in Gmail and Google Chat apps
    We’re introducing numerous improvements across the Gmail and Google Chat apps on Android foldables and tablets in order to enhance your productivity when using these devices. | Learn more about Android features in Gmail and Google Chat apps.


    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: 

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

    Available in beta: Policy Visualization across Google Docs, Sheets, Slides and Drive

    What’s changing 

    Currently, when there are security policies applied to documents, spreadsheets, presentations or files, users are given no central explanation of which actions, like downloading, making a copy, or external sharing are restricted. 

    To improve upon this experience, users who are interacting with policy-protected content, such as those with data loss prevention (DLP) rules or trust rules, will now be proactively informed about what actions are prevented by those policies. 

    For example, if a user is interacting with a document affected by DLP-enforced information rights management (IRM) and a Trust Rule, they will see a shield icon, banner, and side panel that informs them of the restricted actions.
    Policy Visualization across Google Docs, Sheets, Slides and Drive


    Who’s impacted 

    End users 


    Why it matters 

    With this update, users will be made aware of which actions they are taking that are disabled on a document, spreadsheet, slide or file due to data protection controls.

    Getting started 

    • Admins: There is no admin control for this feature. 
    • End users: 
      • Any user will be able to see policy visualization if it's active on a document, but the owner of the document is used to determine if it's turned ON. 
      • A shield icon, banner, and side panel will automatically appear when security controls are present. 
      • Visit the Help Center to learn more about the policies that enable Policy Visualization: 

    Rollout pace 

    During the Open Beta period, this feature will be opt-in only. Customers who fill out this form will see the feature enabled in their specified domains within 7 days of sign-up. Customers may submit feedback here or email it to [email protected]


    Availability

    Policy visualization is enabled when the document, spreadsheet, slides or file owner belongs to the following Google Workspace editions: 
    • Business Starter, Standard, Plus 
    • Enterprise Starter, Standard, Plus 
    • Essentials Starter, Enterprise Essentials, Essentials Enterprise Plus 
    • Frontline Starter, Standard 
    • Education Fundamentals, Standard, Plus, the Teaching & Learning Upgrade 
    • Workspace Individual Subscribers 

    Resources 

    Improving calculation speed in Google Sheets

    What’s changing

    We recently announced the latest advancements in Sheets, including that we’ve doubled the speed of calculation in Google Sheets on Google Chrome and Microsoft Edge browsers. This update can improve the speed of actions like formulas, pivot tables, conditional formatting, and more, regardless of your file size. 


    Who’s impacted 

    End users 


    Why it matter 

    Whether you’re a small business owner analyzing revenue, a finance leader managing millions of values, or a brand manager reviewing the latest orders of a product line, seeing changes in your data reflected quickly is important. This update helps to make that possible by improving calculation speed in Sheets on Google Chrome and Microsoft Edge browsers. 


    Getting started 

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

    Rollout pace 

    • This feature is available now for all users.

    Availability 

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


    Resources