Google Sheets Formulas
In this article, you will learn Named Functions and how to use them in Google Sheets.
Named Functions are the newest additions available from late August 2022 in Google Sheets. The role of this function is to name and save your customized formulas with descriptions that allow you to share them with your collaborators in Google Sheets.
Function name: This is a name you want to give to your formula
Function description: This is a description of the formula you created
Argument placeholders: This is a name(s) that works as a placeholder(s) for future input. An argument means a value you enter to run a formula. Once you type an argument, remember you press the “Enter” key. You can skip this part, but we recommend you define argument placeholder(s) to make the formula understandable and easy to follow.
Formula definition: If you choose a cell containing a formula you want to register, this section is automatically filled. However, if you are writing a function from scratch, you must input it here.
Argument description: This is a description(s) of the placeholder(s). For example, you can add a note on what sort of value the user should enter as an argument.
Argument examples: An example(s) of the argument(s) your formula expects.
If you fill out these sections appropriately, they help you remember how the function works and what kind of input it needs and help other viewers and users of the formula understand what it is.
Keep learning with an example. Assume you are an HR manager and created a formula that gives a specific grade to an input order volume of a salesperson.
If the order volume input is;
Over 90, the formula returns A+;
Over 80, it returns A;
Over 60, it returns B;
Over 40, it returns C;
Over 20, it returns D; and
More than 0, it returns E.
If you are interested in how to create your customized formula or the “LAMBDA” function, check this article.
See the following example of how to fill in the items in the pop-up menu for a named function.
Function name: EVALUATION
Function description: This formula returns a grade from A+ to E depending on an order volume.
Argument placeholders: ordervolume (Only lowercase is allowed here)
Formula definition: We replaced “C13” with “ordervolume”
Before the replacement, the original formula was the following: “=LAMBDA(X,IFS(X>90,"A+",X>80,"A",X>60,"B",X>40,"C",X>20,"D",X>0,"E"))(C13)”
After the replacement, “C13” became “ordervolume”
“=LAMBDA(X,IFS(X>90,"A+",X>80,"A",X>60,"B",X>40,"C",X>20,"D",X>0,"E"))(ordervolume)”
Argument description: The number of orders a salesperson acquired
Argument examples: 50
Once you press “Create” button, your unique formula is registered. This information on the formula shows up when you or other collaborators use it, as shown below.
The picture below shows what the sample registered formula looks like. The formulas in both tables work similarly, but the Named functions look much more straightforward.
See this article to learn how to import Named Functions in Google Sheets.
Are you learning this function to process financial data, build a financial model, or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access more than fifty templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.
To learn more about LiveFlow, book a demo.
Learn how to do this step-by-step in the video below 👇
