‍

In this article, you will learn how to import the Named Functions you created in a different file into another file. If you want to know about the Named Functions, read this article.

‍

‍

How to call the Named Functions from another Google Sheets file

‍

• Type “sheet.new” in a browser to open a new sheet.

‍

• Go to the “Data” tab → “Named functions”.

‍

• Click “Import function” at the bottom of the pop-up on the right.

‍

• Select the Google Sheets file that contains the Named Functions you want to import.

‍

• Choose if you import all Named Functions or if you import only selected Named. Functions. To import all formulas, click “Import all”. To import functions selectively, check the boxes next to the formulas you need to import and click “Import”.

‍

• To use the imported formulas, you can (i) type their names directly in cells, (ii) go to the “Data” tab → “Named functions” to show the Named Functions list, or (iii) move to the “Insert” tab → “Functions” → “Named functions”.

‍

   Your next financial spreadsheet could be right here!

   100+ spreadsheet templates, from FP&A to tax planning.

   Free Spreadsheet Templates

‍

‍

The following pictures show how to go through steps 2 to 5 above.

‍

Step 2: Go to “Data” → “Named functions”

‍

‍

‍

Step 3: Go to “Import function”

‍

‍

‍

Step 4: Selection of the file

‍

‍

‍

Step 5: Selection of the Named Functions

‍

‍

   The world's top businesses trust LiveFlow to automate their financial reporting

   We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!

   Book a Demo