Google Workspace Changes

Beta program to double cell limits to 20 million

Google is introducing a beta program that allows organizations to double their cell limit in Google Sheets, increasing it from 10 million to 20 million cells. This increased capacity applies to new, existing, and imported files for participating organizations.

Gemini in Google Sheets now enables the creation and editing of complex spreadsheets using natural language.

Google has introduced advanced Gemini capabilities in Sheets that allow users to build entire spreadsheets, including data retrieval and formatting, from a single natural language prompt. The update features 'Workspace Intelligence' to synthesize data across Workspace apps, side-by-side editing for refining existing models, and advanced task fulfillment for creating pivot tables and complex formulas. Additionally, it incorporates advanced optimization powered by Google DeepMind and Google Research OR-Tools to solve complex optimization problems without requiring manual formula configuration.

Google Sheets is updating logic and parameter support for specific functions to improve error visibility and data control.

Google Sheets is introducing enhancements to a targeted set of functions to improve error surfacing, parameter support, and calculation logic. Informational and statistical functions like HYPERLINK and T.TEST will now more accurately flag underlying errors; statistical distribution functions such as HYPGEOM.DIST now support additional parameters for better external file compatibility; and financial and array functions like CUMIPMT have been refined for more precise and predictable results.