Google Sheets New Features: Named Functions + Powerful Functions Bundle

Question

Hi everyone,
 
We're excited to announce new features launching soon on Google Sheets: Named Functions + Powerful Functions Bundle
 
We&rsquo;re introducing Named functions, a new feature that allows you to create high-performance custom functions that support built-in Sheets formula constructs. To maintain reusability across files, you can also import named functions from existing Sheets files, allowing you to use functions created in one Sheet in another.

We&rsquo;re also launching a bundle of new and powerful functions in Sheets:
LAMBDA: Creates and returns a custom function, given a set of names and a formula_expression which uses them. The formula_expression can be calculated by calling the returned function with as many values as the names declared. 
Lambda Helper Functions MAP, REDUCE, BYROW, BYCOL, SCAN, MAKEARRAY: Advanced array-operating functions which accept a reusable lambda as an argument along with an input array(s). 
MAP: Maps each value in the given arrays to a new value by application of a LAMBDA function to each value.
REDUCE: Reduces an array to an accumulated result by application of a LAMBDA function to each value.
BYROW: Groups an array by rows by application of a LAMBDA function to each row.
BYCOL: Groups an array by columns by application of a LAMBDA function to each column.
SCAN: Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step.
MAKEARRAY: Returns an array of specified dimensions with values calculated by application of a LAMBDA function.
XLOOKUP: Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match.
XMATCH: Returns the relative position of an item in an array or range that matches a specified value. XMATCH supports enhanced match and search functionality and allows wildcard matches with a question mark (?) or asterisk (*).
 
Why it matters
 
This feature builds upon our intelligent corrections for formulas and suggestions for formulas and functions in Sheets. Additionally, it provides greater flexibility, readability, and reusability within and across Sheets. 
 
Getting started
 
Admins: There is no admin control for this feature.
End users: 
In Sheets, navigate to Data > Named functions > enter details > Next > Create. You can then enter your custom formula into a Sheets&rsquo; cell.
 
Rollout pace
 
Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on August 24th, 2022 
 
Availability
 
Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, and Education Plus customers
Not available to Frontline, Nonprofits, as well as legacy G Suite Basic and Business customers
Available to users with personal Google Accounts
 
Let us know if you have any comments or questions.
 
Best,
Niharika, on behalf of the Google Sheets Team