Arrow left
Back to product guides
Google Sheets Formulas

How to Use Named Function in Google Sheets

In this article, you will learn Named Function and how to use them in Google Sheets.

What is the Named Function 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.

How to name formulas in Google Sheets

  1. Right-click the cell that contains the formula you want to generalize. Go to “View more cell actions” “Define Named function”, which brings up a pop-up on the right side. 
  2. If you want to create and name a formula from scratch, go to “Data”“Named function”. Click “Add function” at the bottom of the pop-up menu on the right side.
  3. In the pop-up, you enter “Function name”, “Function description”, “Argument placeholders”, “Formula definition”, “Argument description”, and “Argument examples” (See our descriptions of each item beneath the screenshots).
  4. Press “Create” at the bottom of the pop-up.
How to show up a pop-up menu of a Named Function

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.

What a customized formula looks like in Google Sheets

See the following example of how to fill in the items in the pop-up menu for a Named function.

What a pop-up menu for the Named Function looks like

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.

How information about a registered formula shows up when you use it

The picture below shows what the sample registered formula looks like. The formulas in both tables work similarly, but the Named function looks much more straightforward.

What a Named function looks like in comparison with the original formula in Google Sheets

How to insert Named Functions in Google Sheets

  1. Type “=” and the name of the formula you want to insert or go to the “Insert” tab → “Function”“Named functions” → The function you want to enter
How to insert a Named function in Google Sheets

How to view a list of Named functions in Google Sheets

  1. Go to the “Data” tab → “Named functions”.
  2. You can see a list of Named functions on the right.
How to insert Named functions in Google Sheets

How the Named functions list looks like in Google Sheets

How to import a Named function in Google Sheets

See this article to learn how to import Named Functions in Google Sheets.

Analyze your live financial data in a snap

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.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711