[go: up one dir, main page]
More Web Proxy on the site http://driver.im/

What’s changing
Since introducing tables in Google Sheets, we’ve made numerous improvements to ensure users are equipped with the tools they need to accelerate spreadsheet building. Table references, a way to refer to a table or parts of a table in a formula, are just one example of how tables reduce time spent manually formatting data. 

Today, we’re excited to announce updates to table references that enhance discoverability and usability. Specifically, users will now see: 
  • Improved table reference availability, which allows users to reference the items below across both single (e.g., =Table2[[#ALL],[Column 1]]) and multiple columns (e.g., =Table2[[#ALL],[Column 1]:[Column 2]] ): 
    • Full table columns, including column headers, data, and footers (#ALL) 
    • Table headers (#HEADERS) 
    • Table footers (#TOTALS) 
    • Table data, excluding headers and footers (#DATA) 
      Improved table reference availability
  • Formula suggestions, which help you identify formulas that could be more robust. For example, if a user types a working formula that overlaps with a table range, a table reference suggestion will show. 
Formula suggestions
  • Formula corrections for table references, which show a formula correction with a proper table reference when a formula is written incorrectly. 
Formula corrections

Getting started 
Rollout pace 
Availability
  • Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts
Resources 
Labels: ,

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




Import data into group chats using the Google Chat API 
In September, we introduced a feature through the Google Workspace Developer Preview Program that enables developers to create group chats in import mode using the spaces.create method when migrating to Google Chat from other messaging platforms. This week, we’re excited to announce that this is now generally available for Google Workspace developers. | Roll out to Rapid Release domains and Scheduled Release domains is complete. | Available to all Google Workspace customers. | Learn more about import mode. 


Search for and reuse pre-defined queries from BigQuery in Connected Sheets
Currently, users can define saved queries in BigQuery Studio and notebooks, but they cannot reuse those queries in Connected Sheets without copy/pasting them. This week, we’re excited to announce that users can now search for and reuse pre-defined queries directly from BigQuery to load Connected Sheets data. To do so, go to Connection Settings > Edit connection > Saved queries and query editor and search for your query by project. | Rolling out now to Rapid Release and Scheduled Release domains at an extended rollout pace (potentially longer than 15 days for feature visibility), with expected completion by December 6, 2024. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Visit the Help Center to learn more about writing & editing a query and getting started with BigQuery data in Google Sheets. 

Search for and reuse pre-defined queries from BigQuery in Connected Sheets


Launching to beta: Import sensitive Microsoft Word documents as client-side encrypted Google Docs. 
Beginning this week, eligible customers can import and convert sensitive Microsoft Word files into Google Docs with client-side encryption. When collaborating with external and internal stakeholders, you may find yourself working across both Google Docs and Microsoft Word. This update keeps your work moving by layering interoperability on top of the confidentiality benefits of client-side encryption: customers are in direct control of their encryption keys and the identity service that they choose to authenticate for those keys. Eligible Google Workspace admins can use this form to request access to the beta. | Available to Google Workspace Enterprise Plus, Education Plus, and Education Standard customers. | Visit the Help Center to learn more about client-side encryption. More specific instructions will be shared once you’re accepted into the beta. 


Select Google Chat settings can now be applied at the group level 
Admins can now apply the following Google Chat settings at the group level: 
While these settings can also be configured at the Organizational Unit (OU) level, this update provides more granular control for admins. This is critical for our customers, who frequently request more flexibility in how they apply settings, giving them more flexibility on how to configure settings based on the various needs of their users. | Roll out to Rapid Release domains and Scheduled Release domains is complete. | Available to all Google Workspace customers.


Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


View in-meeting chat messages in Google Meet live streams 
Starting this week, when you’re viewing a Google Meet live stream, you will be able to see chat messages that are sent by participants who have joined via the meeting link. | Learn more about in-meeting chat messages in Meet live streams. 


Now generally available: use Gemini in the side panel of Workspace apps in seven additional languages 
Beginning this week, select users can use Gemini in the side panel of Google Docs, Google Sheets, Google Drive, and Gmail, in seven additional languages: French, German, Italian, Japanese, Korean, Portuguese and Spanish. | Learn more about additional Gemini languages. 


Announcing general availability of Google Vids: Our new AI-powered video creation app for work to help tell stories across your organization 
Earlier this year, we announced Google Vids, the newest productivity app in our suite of Google Workspace products. Vids is an AI-powered video creation app for work designed to help teams in customer service, learning and development, project ops and marketing tell more engaging stories at work through video. This week, we’re excited to announce the general availability of Google Vids for select Workspace editions. | Learn more about Vids. 


Google Vids is now available for Google Workspace for Education, providing easy video creation for teaching and learning 
Earlier this year, we announced Google Vids would soon empower educators and students to easily create and collaborate with video. This week, we’re excited to announce the general availability of Google Vids for Education Plus and Gemini for Workspace customers. | Learn more about Vids for EDU.


Introducing a refreshed library of high-quality Google Slides templates that elevate your presentations
We’re introducing a new collection of modern, professionally designed templates in Google Slides to help users build presentations much faster. These new templates cater to a wide range of use cases that provide users with the perfect starting point for their presentations. | Learn more about Slides templates.


Expanding access to the Gemini app for teen students in education
Google Workspace for Education admins can now turn on the Gemini app with added data protection as an additional service for their teen users (ages 13+ or the applicable age in your country) in the following languages and countries. | Learn more about the Gemini app for teen students in education.


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).  
Labels: , , , , , ,

 What’s changing

Beginning today, all users* can use Gemini in the side panel of Google Docs, Google Sheets, Google Drive, and Gmail,  in seven additional languages:

  • French
  • German
  • Italian
  • Japanese
  • Korean
  • Portuguese
  • Spanish


Gemini in the side panel of Gmail in Spanish



With Gemini in the side panel of your Workspace apps, you can get help summarizing, analyzing, and generating content by utilizing insights gathered from your emails, documents, and more—all without switching applications or tabs. Check out our original announcements for Gemini in the side panel of Docs, Sheets, and Drive, and Gmail for even more information.

*Available for Workspace customers with a Gemini Business, Gemini Enterprise, Gemini Education, and Gemini Education Premium add-on.
Additional details
  • While Gemini in the side panel of Docs, Sheets, Drive, and Gmail, is generally available in these additional languages - as we keep rolling out more Gemini alpha features in the side panel, end users with Gemini alpha features turned on may continue to see the “Alpha” badge. 
  • Image generation is not supported yet in these additional languages.
  • Gemini in the side panel of Slides is only available in English at this time.
Getting started
  • Admins: There is no admin control for this feature.
  • End users: You can access the side panel by clicking on “Ask Gemini” (spark button) in the top right corner of Docs, Sheets, Drive, and Gmail on the web. Visit the Help Center to learn more about collaborating with Gemini in the side panel of Docs, Sheets, Drive, and Gmail. Note that for accessing other Gemini for Google Workspace features that are supported in English only, you will need to set your Google Account language to English.
Rollout pace


Availability
Available for Google Workspace customers with a:
  • Gemini Business or Enterprise add-on
  • Gemini Education or Education Premium add-on
  • Google One AI Premium 

Resources

Labels: , , , , ,

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

Apply black & white filter to Google Drive scans on Android devices 
In August, we announced that you can now save files scanned in the Google Drive Android app as a .JPEG. This week, we’re excited to introduce an additional scanning option that gives you the ability to apply a black & white filter on your document scans. This new filter helps enhance texts and other important elements, ensuring they are sharply defined when compared to the background region. | 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. | Visit the Help Center to learn more about scanning files with your mobile device.
Apply black & white filter to Google Drive scans on Android devices

AI Classification now supports Field Selection for Model Training 
When AI Classification first launched, Labels eligible for model training needed to have a single field of either a badge or option-list field type, and Labels with multiple fields were ineligible. Now, customers that use AI Classification will be able to select which badge or option list field they would like to train a model for after identifying the target label. Once trained and enabled, the AI model will automatically apply the label and will only populate the selected field. | Roll out to Rapid Release and Scheduled Release domains is complete. | Available to customers with the AI Security add-on, Gemini Enterprise add-on, and Gemini Education Premium. | Visit the Help Center to learn more about Label Google Drive files automatically using AI classification. 


Reducing noise from unfollowed threads in Google Chat
In order to make it easier to identify which unread threads are most relevant to you, we’re reducing the noise by removing visual cues from threads that you do not follow in Google Chat. Starting this week, new activity, such as unread messages from threads you do not follow, will no longer bold and appear at the top of your conversation lists. | Rolling out now to Rapid Release and Scheduled Release domains on web and mobile at an extended rollout pace (potentially longer than 15 days for feature visibility). | Available to all Google Workspace customers. 


Introducing a better filter by condition experience for tables in Google Sheets 
Tables in Google Sheets will now provide users with a smarter filter by condition experience. Sheets offers 21 options for users to filter by condition, such as “Date is” or “Text ends with”. However, we know there are scenarios in which certain filters might not be applicable based on the type of data in a spreadsheet. Based on the set column type, users will now only see relevant filter by condition options. For example, if your column type is set to number, the filter options will be number-based only. | Roll out to Rapid Release and Scheduled Release domains is complete. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Visit the Help Center to learn more about sorting & filtering your data.
Introducing a better filter by condition experience for tables 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.


Refine emails faster with updates to the “Polish” shortcut in Gmail 
We’re expanding the Help me write shortcut to web and introducing a Polish shortcut on web and mobile that helps you refine emails even faster. | Learn more about email shortcuts in Gmail. 

Google Classroom now supports exporting missing and excused grades to select Student Information Systems (SIS)
Teachers can now include missing and excused grades when exporting grades to their Student Information Systems (SIS). | Learn more about exporting missing and excused grades to select Student Information Systems (SIS). 

New density setting in Google Chat 
To give users more control over how they see information in Google Chat, we’re introducing a new setting that allows you to control the visual density of screen elements. Choose between “Comfortable” or “Compact” on chat.google.com. | Learn more about density settings in Chat.

Context Aware Access insights and recommendations are now generally available
We’re making it easier to apply context-aware access (CAA) policies with new insights and recommendations. We’ll proactively surface potential security gaps and suggest pre-built CAA levels which admins can deploy to remediate the security gaps. | Learn more Context Aware Access insights.

FedRAMP High authorization for Gemini for Workspace 
As recently announced, we submitted our package to obtain FedRAMP High authorization for Gemini for Workspace, including the Gemini app. A FedRAMP High certification assures federal agencies in the United States that a cloud service provides the highest level of protection for their most sensitive data, enabling them to confidently leverage cloud technologies for critical operations. | Learn more about FedRAMP High authorization for Gemini.

Gemini in the side panel of Google Chat is now available
We’re expanding Gemini in Chat to help users collaborate more effectively in their spaces, group messages and direct messages. | Learn more about Gemini in the side panel of Chat. 

Data classifications labels for Gmail are now available in open beta
In addition to Google Drive, we’re expanding data classification labels to now include Gmail. Classification labels are used to classify and audit content according to organizational guidelines (“Sensitive”, “Confidential”, etc.) and apply policies, such as data loss prevention (DLP) rules, to protect sensitive information in email messages. Classification labels will be available when using Gmail on the web – support for Gmail on mobile devices will be introduced in the coming months. | Learn more about the beta for data classifications labels for Gmail.


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


    Labels: , , , , , , ,

    Update

    [November 20, 2024] We have updated the rollout information for this feature. See the Rollout section below for more details.

    [October 31, 2024]     We have updated the rollout information for this feature. See the Rollout section below for more details.

    What’s changing

    Earlier this year, we introduced a new comments experience in Google Docs, Sheets, and Slides on web. Today, we’re announcing a similar update to Android tablets for viewing, navigating, and replying to comments, especially on-the-go. In addition to improved design and filtering functionality to match the web experience, you’ll now be able to easily: 

    • Keep a pulse on the latest updates: now you’ll see the first comment and the two most recent replies from a comment thread, with the option to show all comments within a discussion.
    • Review comments with full context: enjoy familiar, in-context commenting, similar to the web experience, while taking advantage of larger screen real estate on tablets. 
    • Navigate and filter comments: navigation tabs and filters within the comments panel help you easily find relevant comments, without having to switch to a separate view.
    Comment experience in Docs

    Comment experience in Docs
    Comment experience in Sheets

    Comment experience in Sheets

    Comment experience in Slides

    Comment experience in Slides

    Getting started 

    Rollout pace 
    • Rapid Release domains: Available now for Google Sheets and Google Slides. Extended rollout (potentially longer than 15 days for feature visibility) starting on November 7, 2024 for Google Docs, with expected completion by December 2, 2024
    • Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on December 3, 2024
    Availability 
    • Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts 
    Resources 
    Labels: , , , ,

    What’s changing

    You can now use Gemini in the side panel of Google Docs, Google Sheets, Gmail, and Google Drive in seven additional languages:

    • German
    • Italian
    • Japanese
    • Korean
    • Portuguese
    • Spanish
    • French 

    The additional languages are available in alpha for Workspace customers with a Gemini Business, Gemini Enterprise, Gemini Education, and Gemini Education Premium add-on. Admins can use our Help Center to learn more about turning access to Gemini for Google Workspace Alpha features on for your users.

    With Gemini in the side panel of your Workspace apps, you can get help summarizing, analyzing, and generating content by utilizing insights gathered from your emails, documents, and more—all without switching applications or tabs. For more information, please refer to our original announcements for Gemini in the side panel of Docs, Sheets, and Drive, as well as Gmail respectively.

    Getting started


    Labels: , , , , , ,

    What’s changing 
    Last year, we introduced the ability to pull rich data from apps directly into Google Docs with third-party smart chips. Since then, many users have embedded content from partner apps, including Asana, Jira & Confluence, Canva, Lucid, Loom, Whimsical, and Zoho Projects, and now we’re expanding the capability to Google Sheets. 

    Starting today, users can add smart chips that pull information from third party apps into Sheets. Users can also paste third-party chips inserted in Docs directly into a spreadsheet. 

    To access third-party smart chips, an admin or user must first install a partner’s add-on from the Google Workspace Marketplace. After that, simply paste a link from the third-party source into your spreadsheet and click “tab”. You will then see a smart chip populate in your sheet that previews critical information from the app, right in the flow of your work. 
    Third-party smart chips in Google Sheets
    Getting started 
    • Admins: You can only create and use a third-party smart chip if a developer has enabled it for that application. You will also need to install or allowlist the specific add-on for that application to ensure end users have access. Visit the Help Center to learn how to install Marketplace apps in your domain and managing Google Workspace Marketplace apps. 
    • Developers: Visit the Help Center to learn more about how to make third-party smart chips. 
    • End users: 
      • Specific add-ons for third-party applications must be installed by your admin or allowlisted for you to use this feature. Visit the Help Center to learn more about inserting third-party smart chips from other applications. 
      • To convert a link to a third-party into a smart chip, you can either: 
        • Paste a link from the third-party source into your spreadsheet and select “tab” 
        • Replace the link with a chip within the hover card that appears when you place your cursor over the link. 
    Users who have installed a third-party add-on will see a hovercard of information defined by the third-party upon hovering over the chip: 
    Users who have installed a third-party add-on will see a hovercard of information defined by the third-party upon hovering over the chip

    Rollout pace

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

    Resources 
    Labels: ,

    What’s changing

    We’re pleased to announce that the use of comments and action items are now available in client-side encrypted Google Sheets and Slides. This includes the ability to add, edit, reply, filter, or delete comments, as well as assign action items to yourself or others. This is already available for client-side encrypted Google Docs. Expanding this functionality to Sheets and Slides makes it easier to collaborate across encrypted documents.


    Using comments in a client-side encrypted sheet

    Additional details
    Note that when sharing encrypted files, you can only assign “viewer” or “editor” permissions. “Commenter” permission is not supported. Viewers can view comments. Comments are saved each time the document is autosaved. If you restore the document to a previous version, the comments added to the document in that version are also restored.

    Getting started
    Rollout pace
    • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on October 2, 2024
    • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on October 22, 2024

    Labels: , ,

    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.



    Use Gemini in Google Sheets to generate structured tables
    We’re excited to announce that users can now generate structured tables with Gemini in the side panel of Google Sheets. Prior to this update, tables were output as plain text ranges without set column types or structure. Now, Gemini can help you simplify and accelerate spreadsheet building by bringing format and structure to unorganized ranges through table generation. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for October 17, 2024. | Available for Google Workspace customers with Gemini Business, Enterprise, Education, Education Premium add-ons and users with the Google One AI Premium subscription. | Visit the Help Center to learn more about using tables in Google Sheets.
    Use Gemini in Google Sheets to generate structured tables
    Refreshed illustrations in the Google Calendar app on Android and iOS devices
    We’re introducing more modern illustrations for Google Calendar events like coffee, lunch or doctors appointments on Android and iOS. You’ll also notice updated monthly illustrations for background images in the schedule view on your mobile device or tablet. | 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. 
    Refreshed illustrations in the Google Calendar app on Android and iOS devices

    New “Gemini Advanced” branding for Gemini for Google Workspace add-on users
    The Gemini app (gemini.google.com) will now display a "Gemini Advanced" label for users with a Gemini Enterprise, Business, Education, Education Premium add-on. This will better indicate to users the advanced capabilities of the app included in these plans. We're also updating this branding across our Help Center to better indicate which features and settings are specific to these add-ons. | Rollout to Rapid Release and Scheduled Release domains is complete. | Visit the Help Center to learn more about Gemini for Google Workspace.
    New “Gemini Advanced” branding for Gemini for Google Workspace add-on users

    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.


    Kickstart ideas, brainstorm activities, and differentiate content with the help of Gemini in Google Classroom 
    This week, we officially introduced a new Gemini Education tab in Classroom that grants quick access to numerous AI tools. | Learn more about Gemini in Classroom. 

    Introducing security advisor, a new set of tools and insights to help small businesses protect their organization against cyber attacks 
    To help small businesses, we’re introducing security advisor, a set of new insights and tools designed to enhance security for small businesses – including threat defense, account security, and data protection capabilities. | Learn more about security advisor. 

    Customize your Google Docs with polished cover images 
    We’re making it easy for you to personalize and differentiate documents with full-bleed cover images that extend from one edge of your document to the other. | Learn more about cover images. 

    Preview and test upcoming features on Google Meet hardware devices 
    Using the new “Feature preview” setting, specific Google Meet hardware devices can be configured to test upcoming features prior to general availability. | Learn more about testing Meet hardware features. 

    Gmail allows more senders to protect their brand using BIMI Common Mark Certificates 
    We introduced two additional updates for BIMI that will continue to keep inboxes safe: Gmail now supports Common Mark Certificates (CMC) and BIMI verified check marks are now displayed on Android and iOS. | Learn more about BIMI Common Mark Certificates. 

    Google Sheets tables are now integrated with conditional notifications 
    There is a new integration between conditional notifications and tables in Sheets. | Learn more about tables and conditional notifications. 

    Gemini in Gmail will now provide contextual Smart Replies 
    We’re excited to announce a new Gemini in Gmail feature, contextual Smart Replies, that will offer more detailed responses to fully capture the intent of your message. | Learn more about contextual Smart Replies.

    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). 
    Labels: , , , ,

    What’s changing 
    Earlier this year, we introduced tables in Google Sheets, a feature that accelerates spreadsheet building by formatting and organizing your data into a polished design with column types, filters, color coding, dropdown menus and more. A month later, we added conditional notifications to provide you with greater visibility into spreadsheet changes most relevant to your workflow via email notifications. 


    To bring these features closer together, we’re excited to announce a new integration between conditional notifications and tables in Sheets. 


    As a result: 
    • Conditional notification rules can now be directly applied to tables and will recognize table column names. 
    • All tables now come with a new, easy entry point to conditional notifications in the controls header. 
    • Common conditional notifications will now be built-in to pre-built tables by default and can be enabled with a single click. 
    setting up conditional notifications in table in sheets


    Notified users will receive a detailed email that shows changes made to a Sheet: 
    detailed email that shows changes made to a Shee
    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 add or view conditional notifications on your table by clicking on the lightning bolt icon on the table header. From here, you can view and choose to enable, disable, delete, or edit any existing rules. 
        • Up to 10 rules can be added to a spreadsheet. 
        • The rules are assigned default names automatically. However, you can update the name of the rule by utilizing the text editor. 
      • Please note: we group notifications for a better experience and they may take up to 30 minutes to send. 
      • Visit the Help Center to learn more about how to use conditional notifications and tables in Sheets. 
    Rollout pace 
    Availability 
    Available for Google Workspace: 
    • Business Standard, Plus 
    • Enterprise Starter, Standard, Plus 
    • Education Plus 
    • Enterprise Essentials, Enterprise Essentials Plus
    Resources
    Labels: ,

    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 the table range, excluding header cells, you would input: =IMPORTRANGE(spreadsheet_url, “Table1[#DATA]”) 
    3. Use the following keyboard shortcuts to easily convert ranges to tables: 
    • Cmd+Opt+T for Mac 
    • Ctrl+Alt+T for Linux and Windows 
    • Shift+Alt+T for Chrome OS 
      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).  
      Labels: , , , , ,

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

      Labels: , , , ,