The latest update to Google Sheets will have fans of formulas salivating with excitement which makes Google Sheets formulas more powerful.
Google Workspace‘s spreadsheet software now offers named functions, allowing users to write high-performance custom functions that complement built-in Sheets formula constructions.
Users can import named functions from existing Sheets files, enhancing spreadsheet reusability.
Equation functions in Google Sheets
“Named functions allow better formula flexibility, readability, and reusability within and across Sheets,” Google noted.
Users can add a personalised formula into a Sheets cell once they enable the option by going to Data > Named functions > Add new function > enter details > Next > Create.
If you’ve made some custom named functions in one Sheets file and want to use them in another, you’ll need to import them by going to Data > Named functions > import function > choosing the appropriate file.
Google said the introduction builds on other recent formula advancements, including its intelligent corrections tool, launched in April 2022 to help users improve and fix calculations.
Excel evaluates formulas to see whether there’s room for improvement. If so, a suggestion box will display with details on a new version that can replace the present formula.
Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, and Education Plus clients, as well as personal Google Account users, can now access the new functionalities feature.
Hence Frontline, nonprofits, and older G Suite Basic and Business clients won’t have access.
Google also showed several additional new functions, including LAMBDA, which constructs a bespoke function from a list of names and a formula expression.
XLOOKUP, which returns the result range based on the lookup position, and XMATCH, which returns the relative position of an item in an array or range that matches a specified value.