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
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.
