WorryFree Computers   »   [go: up one dir, main page]

Quick Summary 

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

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

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




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

Getting started 

  • Admins: There is no admin control for these features. 
  • End users: This feature will be available by default and can be disabled by going to Tools > Enable formula corrections or from the three-dot menu of the suggestion dialog box. Visit the Help Center to learn more about using formulas and functions in Google Sheets. 

Rollout pace 

Availability 

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

Resources 

Labels: , ,

Quick launch summary 
Google Meet now supports SRTP in TLS on mobile, which increases overall compatibility and helps ensure higher quality video meetings with Google Meet. 


In addition, Meet is introducing support for UDP port 3478 to deliver media (Note that existing ports 19302–19309 deliver media as well). 


Getting started 
  • Admins: If you already use Meet today, configure your network to support Meet on port 3478. Note: If the port is blocked, Meet will fallback to port 19302​–19309. If you use DPI technology on port 443, add the corresponding user SNIs to the allowlist: 
    • Google Workspace admins: Meet traffic over TLS and port 3478 will use the same fixed IP range dedicated for Google Meet in Google Workspace domains. 
    • Non-Google Workspace admins: Meet traffic over TLS and port 3478 will use the fixed IP range dedicated for non-Google Workspace users. 
  • End users: No end-user impact. 

Rollout pace 
Meet traffic over TLS 
  • This feature is available now. 

Meet traffic over port 3478: 

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

Resources 
Labels: , ,

What’s changing 
We’re introducing a new AppSheet and Apps Script connector which allows you to extend custom, no-code apps to integrate and automate workflows across Google Workspace. 


The Apps Script Connector will be available for users in the AppSheet Core plan and above, which is available to users of the Google Workspace Enterprise edition. Users in the AppSheet Starter plan can test the feature. Learn more from AppSheet documentation. 


Who’s impacted 
Admins, end users, and developers 


Why it matters 
AppSheet is Google’s platform for building no-code custom apps and workflows to automate business processes. AppSheet works well with mixed data sources, even if customer data is stored across Sheets, CloudSQL, or on-premise databases. 


Apps Script is Google’s hosted JavaScript platform that makes it easy to build solutions that integrate, automate, and extend Google Workspace. Apps Script is integrated with Google Workspace APIs and includes native integrations to Google services such as YouTube, Google Analytics, and BigQuery. 


You can use the AppSheet Apps Script connector to extend custom no-code apps to integrate and automate workflows across Google Workspace. This is useful in a variety of scenarios, such as use cases in the retail, manufacturing or public sector. For example, you could use the connector with your AppSheet app to: 
  • Receive employee travel requests via the web, and when a request is made, it can look up the requestor’s manager and send a chat or email notification for approval. 
  • Allow workers to capture photos from their mobile device for on-site inspections, and upload images and media to Google Drive and adjust Drive sharing settings to ensure auditors have access. 
  • Manage shift schedules and appointments through a simple web interface, and when a time slot is booked, create an event on Google Calendar with the requestor invited. 


Getting started 

Rollout pace 

Availability 
  • The Apps Script Connector will be available for users in the AppSheet Core plan and above (available to Google Workspace Enterprise, see AppSheet pricing). Users in the Starter plan can test the feature. 

Resources 
Labels: , , ,

What’s changing 
In December 2020, we announced a redesign of the Integrated Development Environment (IDE) for Google Apps Script. The modern and simplified development experience makes it quicker and easier to build solutions that make Google Workspace apps more useful for your organization. 


We’re now adding several new features to the IDE to help achieve functional parity with the legacy IDE experience. These features are: 
  • Script Properties 
  • Add-on Testing 
  • Time Zone Setting 
  • Rhino Debugging 


See below for more information. 



Who’s impacted 
Admins and developers 



Why it’s important 
Apps Script is a rapid application development platform that makes it fast and easy to create custom business solutions that integrate with Google Workspace and that increase the power of apps including Calendar, Docs, Drive, Gmail, Sheets, and Slides. For more information, see the original announcement on the Workspace Updates Blog. 


This launch ensures Apps Script users can utilize the legacy features in the new environment: 
  • Script Properties: Allows you to store simple data in key-value pairs scoped to one script. Script properties are typically used to store developer configuration data. The new IDE has now integrated the interface to edit, delete and create up to 50 new script properties. 
  • Add-on Testing: Allows add-on developers to test their add-ons before publishing them broadly.
  • Time Zone Setting: Allows you to update the time zone of the script and its executions. 
  • Rhino Debugging: Adds the ability to debug Rhino subroutines on V8 debugger, without migrating to V8. If the code is not V8 compatible, users will get a warning message. 

We hope these additional features empower you to create solutions and integrations for Google Workspace applications faster and easier. 


Getting started 

Rollout pace 

Availability 
  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basic, Business, Education, Enterprise for Education, and Nonprofits customers 

Resources 
Labels: , ,

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



Who’s impacted 
Admins and end users 


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

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


Getting started 

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

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

Resources 

Roadmap 
Labels: , , , ,

Quick summary 
In the Alert Center, Admins will see new, additional one-click recommended actions for certain events: 

  • Device wipeout: for “device compromised” and “suspicious device activity” alerts. If the admin feels blocking the device is not sufficient to protect the data at risk, they can can remotely wipe out the data of the device.

  • Quarantine email: for alerts such as malware detected post delivery, user phishing reported, suspicious message reported, and more. Once in quarantine, admins can take additional actions such as delivering the message to the intended recipient or denying message delivery.

Recommended actions help Admins quickly triage, take action, and remedy various incidents without leaving the Alert Center. To learn more about recommended actions, use this article in our Help Center and see this post on the Google Workspace Updates blog. 


Getting started 

Rollout pace 

Availability 
  • Available to Google Workspace Enterprise Plus, Education Standard, and Education Plus customers 
  • Not available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Education Fundamentals, Frontline, and Nonprofits, as well as G Suite Basic and Business customers 

Resources 
Labels: , , ,

Quick summary 
You can now apply contextual access rules to the Admin console. This enables you to control access to the Admin console based on user and device context. For example, you can enable restrictions based on IP, minimum device operating system version, and more. This can improve your security posture and reduce the risk of incorrect access to your Admin console. 


Getting started 

Rollout pace 


Availability 
  • Available to Google Workspace Enterprise Standard, Enterprise Plus, Education Standard, Education Plus, and Cloud Identity Premium customers. 
  • Not available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Education Fundamentals, Frontline, and Nonprofits, as well as G Suite Basic and Business customers. 


Resources 
Labels: , , ,

What’s changing 
Previously, users in organizational units (OUs) or groups with active Drive Data Loss Prevention (DLP) policies couldn’t respond to external forms with File Upload questions. 


Now, we’re launching a new beta that will allow users to respond to external forms that contain File Upload questions, while also helping to prevent the leak of sensitive and confidential information. This beta will apply your domain’s existing Drive DLP policies to files that your users submit to Google Forms, without creating new rules or updating any existing ones. 


Admins of eligible customers can express interest in the beta using this form. 




Who’s impacted 
Admins and end users 


Why it’s important 
With this launch, end users will be unblocked from responding to Google Forms with File Upload questions across domains. At the same time, DLP gives admins control over what their users can share, and prevents unintended exposure of sensitive information such as credit card numbers or personal identifiable information. 


Getting started 
  • Admins: 
    • Use this form to express interest in the beta. 
    • Once accepted into the beta, Drive DLP rules defined for your domain will be applied to files submitted to File Upload questions in Google Forms. 
    • If you are not using DLP for Drive, you can create DLP rules at the domain, OU, or group level in the Admin console under Security > Data protection. You can apply block, warn or audit actions, consistent with DLP for Drive. Visit the Help Center to learn more about turning data loss prevention in Google Forms on for your organization. 
  • End users: 
    • End users can respond to forms as usual, but can now respond to forms outside their domain, including forms that have File Upload questions. 
    • If a form violates Drive DLP rules for their domain, end users may see warnings or be blocked from submitting. 

Availability 
  • Available to Google Workspace Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard and Education Plus customers 
  • Not available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Frontline, and Nonprofits, as well as G Suite Basic and Business customers 


Resources 
Labels: , , , , , ,

What’s changing 
We’re introducing two improvements for Google Meet: 
  • Prompts to exit meetings when you’re the only user in a meeting. 
  • A centralized location for host management controls. 

See below for more information. 


Who’s impacted 
End users 


Why you’d use it 
Leave empty call reminders 
Now, when you’re the only person in a meeting for ten minutes, you’ll receive a prompt asking whether you want to stay or leave the meeting. If you don’t respond after two minutes, you will automatically leave the meeting. 




We hope that this feature will help prevent situations where your audio or video is unintentionally shared. 




This feature will be available for Google Meet on desktop and iOS devices (this will launch on Android soon) — see below for availability. 


Host Management controls update 
Currently, host and co-host controls can be found in multiple locations in Meet. For a more user intuitive experience, we’ve consolidated all host and co-host features in a single, central location under the “Host controls” menu. We hope this change makes it easier to manage your meeting settings by reducing the need to switch between various menus. 

This update is specifically for Google Meet on desktop. 


Getting started 
  • Admins: There is no admin action required. 
  • End users: Leave empty call reminders: This feature will be ON by default and can be turned off by the user. Visit the Help Center to learn more. 



  • Host management controls can now be found under the “Host Controls” button located in the bottom bar. 





Rollout pace 
  • Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on April 11, 2022 
  • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on April 18, 2022 

Availability 
Meeting exit reminders
  • Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers Also available to users with personal Google accounts 

Host Management menu updates 
  • The Host management menu updates are available for all users. 
Labels: ,

Quick summary 

Giving and receiving feedback is a key collaborative workflow in Google Docs. The new emoji reactions feature provides a less formal alternative to comments to express your opinions about document content.

We are making the following experiences available in Docs 

  • Emoji set is updated to the latest version (Emoji 14.0), reflecting the latest emoji set with options to accurately reflect your identity 
  • Gender-neutral options for gender-modifiable emojis 
  • Emoji skin tone and gender preferences are saved per individual emoji 






Getting Started

  • Admins:There is no Admin control for this feature
  • End users: This feature will be ON by default and can not be disabled by the user. To access reactions in Docs, hover over any message or an existing anchor and click on the “Add reaction” icon. Additionally, emoji preferences are shared with Google Chat, so any preferences set in one app will be reflected in the other. Both apps can be used to update emoji preferences via the picker. Visit the Help Center to learn more about using emoji reactions in Google Docs

Rollout pace 

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

Resources 

Roadmap 
Labels: ,