The Google Workspace Blog announced a new Sheets feature that lets you create custom functions that can be reused in all files. The feature, called “Named Features”, is similar to named ranges where you can select a specific range of cells and give them a unique name to reference them in a formula.
Named functions can be imported from existing Sheets files, allowing greater flexibility when working with complex formulas and ultimately simplifying the process. The feature builds on recent improvements to smart corrections and formula suggestions in Google Sheets.
To create a new named function in Sheets, navigate to Data > Named Functions > Add New Function > enter details > Next > Create. Once the custom function is created, you can then type it into a sheet cell to use it. Note that named functions that are created in a file are only available in that file and will need to be imported into the new file in order to use it. You can do this by selecting Data > Named Functions > Import Function > and choose the function you want. Plus, the new formulas below are now available in Sheets to make your formulas even more powerful:
• LAMBDA: Creates and returns a custom function, given a set of names and a formula_expression that uses them. The formula_expression can be calculated by calling the returned function with as many values as declared names.
• Lambda helper functions – MAP, REDUCE, BYROW, BYCOL, SCAN, MAKEARRAY: Advanced array mining functions that accept a reusable lambda as an argument with one or more input arrays.
• XSEARCH: Returns values in the result range based on where a match was found in the search 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
. These changes will have no impact on the administration and have starteddeployment yesterday, August 24. Rapid and Scheduled Release domains will begin to see the new feature appear gradually for up to two weeks
. The Google Workspace tiers below are eligible:
Availablity • Available for:
Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus customers and users with personal Google Accounts • Not available for:
Frontline, nonprofits, and former G Suite Basic and Business customers
It’s great to see these new features being made available to users with personal accounts, not just business users. I can see myself using named functions if I reuse the same formula over and over, even for simple sheets like a budget or an invoice. I hope this is a trend that will continue.