Author Archives:

Greater control and error visibility for Google Sheets formulas

We are introducing updates to the logic and parameter support for a targeted set of Google Sheets functions. These changes are designed to improve error visibility, offer more control over data, and ensure seamless compatibility when importing files.

Specifically, you will notice improvements across several categories of functions, including:

Better error surfacing: Select informational and statistical functions (such as HYPERLINK, VALUE, and T.TEST) will now more accurately flag underlying errors, like broken URLs or zero-variance denominators, preventing potential data issues from being masked.
Enhanced parameter support: Several statistical distribution functions (such as HYPGEOM.DIST, NORM.S.DIST, and LOGNORM.DIST) now support additional parameters, allowing for greater control and ensuring they import smoothly from external spreadsheets.
Refined calculation logic: Select financial and array functions (such as CUMIPMT and FREQUENCY) have been updated to provide more precise and predictable results based on your specific data inputs.

These enhancements reduce friction and provide more trustworthy outcomes for users who rely on precise mathematical behaviors. You can now troubleshoot complex spreadsheets more effectively and import external files with confidence, knowing your formulas will evaluate as expected. For a comprehensive list of Sheets functions and their specific inputs and behavior, please visit our Help Center.

Getting started

Admins: There is no admin control for this feature.
End users: There is no end user setting for this feature. Visit the Help Center to learn more about how these functions work in Sheets.

Rollout pace

Rapid Release and Scheduled Release domains: Available now

Availability

Google Workspace customers and users with personal Google accounts

Resources

Google Help: Google Sheets function list

Source: Google Workspace Updates

Get more done with new vertical tabs and immersive reading mode in Chrome

These new features are designed to streamline your browser and help you maximize productivity in Chrome.

Source: The Official Google Blog

Chrome Beta for Android Update

Hi everyone! We've just released Chrome Beta 147 (147.0.7727.55) for Android. It's now available on Google Play.

You can see a partial list of the changes in the Git log. For details on new features, check out the Chromium blog, and for details on web platform updates, check here.

If you find a new issue, please let us know by filing a bug.

Chrome Release Team
Google Chrome

Source: Google Chrome Releases

New Data Manager API channels on Discord

We're excited to announce the addition of new channels for the Data Manager API on our “Google Advertising and Measurement Community” Discord server. To join, just click this invite link and follow the onboarding guide.

Our team will be on this server regularly to interact with the Data Manager API community, answering questions and gathering feedback in the #data-manager-api channel. We’ll also keep you up to date on the latest Data Manager API news in the #announce-data-manager-api channel.

If you have any questions or want to discuss this post, please reach out to us on the “Google Advertising and Measurement Community” Discord server. We look forward to seeing you there and hearing your thoughts on how we can continue to improve the Data Manager API!

- Josh Radcliff, Data Manager API Team

Source: Google Ads Developer Blog

Book Google Workspace resources from third-party calendars

Organizations that use both Google Workspace and other calendaring systems, like Microsoft Outlook, can now more easily coordinate shared resources, such as rooms, projectors, or company cars. We are introducing an open beta that allows non-Google users to book Google Workspace resources directly from their preferred calendar service.

Google Workspace admins can grant specific non-Google users or entire non-Google domains permission to book Workspace resources. Once these permissions are configured in the Admin Console, non-Google users can reserve a resource by simply adding its email address to the calendar event guest list. If the resource is configured to auto-reply, it automatically accepts or declines the invitation based on its availability and sends an email notification to the organizer.

Additionally, for organizations using both Google Workspace and Microsoft Outlook, admins can configure Calendar Interop. This allows Outlook users to find and book Workspace resources by their name and view their availability before sending an invite.

Getting started

Admins: This feature is OFF by default and can be configured at the resource level in the Admin console. Admins can specify which non-Google users or entire domains are permitted to book specific rooms. Visit the Help Center to learn more.
End users: Once an admin has granted permission, non-Google users can book a room by adding the resource email as an attendee to their calendar event.