Questions tagged [google-sheets-named-ranges]

For questions involving issues with Named Ranges (a group of cells with assigned custom name) in Google Sheets.

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
20 views

How to Import or Query a Range from Google Sheets into Google Docs?

I'm using Google Docs, the word processor, and am seeking to import a named range sourced in Google sheets into my Google Docs file. Do the field code feature or any other feature in Google Docs ...
0
votes
0answers
10 views

How to reference a Named Range in a formula, if it is also the value in another cell

I have a Named Range named Car. In another tab, I have: A16 reproduces the header of the Named Range: =Categories!C1 A17 lists out the values in the Named Range: =FILTER(Car,NOT(ISBLANK(Car))) If ...
0
votes
1answer
880 views

How to reference a dynamic range in Google Sheets Script?

I have a sheet where the filter originally started on row 2, so my range was A2:J. As I've added and deleted rows/columns, my range has changed and it's still changing as I edit the sheet. Is there ...
0
votes
0answers
21 views

Auto Increment a Named Range in Google Sheets

I am working on a bidding calculator and would like to be able to automatically increment a Name Range once I finalize the formulas once. For instance, there are 15 cells per item row with formulas ...
0
votes
1answer
785 views

How to use calculated fields to pull up “Grand Total” in Google Sheets?

I have a grand total value that I want to use in my calculated field. Instead of using a specific number like =sum(impr./919), I want something like =sum(impr./"grand total") and that the grand total ...
0
votes
1answer
75 views

Formula for adding sum total from multiple sheets for a specific name

I am stuck in terms of how to set a formula to get the sum total for a specific "name" from multiple sheets.