Can a label in a Google Sheets Query be dynamic; can it reference a variable? - Stack Overflow

admin管理员组

文章数量:1122846

In QUERY, labels can be created with a text value. Example: label Col2 'Total'
This will display "Total" instead of the existing label for Column 2.

But what if the query uses a dropdown as a means of filtering the results. In this case, the value of a "new" label might not be predictable and an end user might not be able/permitted to edit the query. So, can a label value be dynamic?

Say Cell A1 contains the word "Total".
Instead of writing label Col2 'Total', is it possible to substitute the value of cell A1 as the new label value?

For instance, if Cell A1 = "Grand Total", the label would change from "Total" to "Grand Total".

In QUERY, labels can be created with a text value. Example: label Col2 'Total'
This will display "Total" instead of the existing label for Column 2.

But what if the query uses a dropdown as a means of filtering the results. In this case, the value of a "new" label might not be predictable and an end user might not be able/permitted to edit the query. So, can a label value be dynamic?

Say Cell A1 contains the word "Total".
Instead of writing label Col2 'Total', is it possible to substitute the value of cell A1 as the new label value?

For instance, if Cell A1 = "Grand Total", the label would change from "Total" to "Grand Total".

• google-sheets
• google-sheets-formula

Share Improve this question Follow asked Nov 22, 2024 at 2:12 TedinozTedinoz 7,87633 gold badges2828 silver badges3939 bronze badges 2

• I'm surprised you didn't know this. – TheMaster Commented Nov 22, 2024 at 6:29
• @TheMaster You're not the only one :) Actually I did try this (no, truly) but I must have mucked up the syntax so I didn't think this worked with labels; hence the question (sigh). – Tedinoz Commented Nov 22, 2024 at 9:47

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Concatenating a range in a Query as a label

Formula:

=QUERY(A2:B7, "SELECT A, SUM(B) GROUP BY A LABEL SUM(B) '" & C1 & "'")

Changing the value in C1 instantly updates the column label in the result.

Instead of hardcoding the formula use the & operator to dynamically refer to the value in C1 or your desired cell.

Sample Output:

Note: I just created sample data to demonstrate how to reference another cell.

本文标签： Can a label in a Google Sheets Query be dynamic can it reference a variableStack Overflow