All Questions
Tagged with google-query-language google-apps-script
51 questions
-1
votes
2
answers
58
views
Query call via Apps Script returning 0 (zero) instead of Data Range
For some reason, historyQuery2 returns the proper data range, but historyQuery1 returns 0.
function getEventHistory(cS,findAcct) {
// copy filtered values from Events sheet to Client sheet (cS)
var ...
0
votes
1
answer
106
views
How to copy selected data from Sheet 1 to Sheet 2 when press a button on Google Sheet?
Select data row from Sheet 1 then press submit to copy to Sheet2
Table on Sheet2 already contains data.
Select Data from Table on Sheet1 by checkbox.
Press the submit button.
Add selected data from ...
0
votes
2
answers
452
views
Google Sheets - Combine Multiple Dynamic Sheets with Different Structure into One Sheet
I am trying to create a cash flow report which should summarize transactions made in several bank accounts.
Every bank account has a separate tab and a different layout, these transactions are ...
- 23
1
vote
1
answer
400
views
Google Sheets - Combine Multiple Sheets with Different Structure into One
I am trying to create a cash flow report which should summarize the transactions made in several bank accounts.
Every bank account has a separate tab and a different layout.
In order to create a pivot ...
- 23
0
votes
2
answers
210
views
Query formula Multiple Columns using "Where", "AND", and Torow
I have multiple sheets in data google sheet, let's both named is sheet 1 and sheet 2. In sheet 1, I have three columns as below:
And in sheet 2, I have three columns in below:
If I want to filter ...
0
votes
2
answers
140
views
Query Multiple Columns with using "Where" and "AND"
I have multiple sheets in data google sheet, let's both named is sheet 1 and sheet 2. In sheet 1, I have three columns as below:
And in sheet 2, I have three columns in below:
If I want to filter ...
0
votes
2
answers
628
views
Custom Google Sheets function and QUERY not updating after sheet name change
Problem:
I am working with a Google Sheets file were the first tab is the 'raw export'. Data in this sheet looks basically like this:
Customer
Item
Cost
Amy
Shirt
15.50
Amy
Pants
20.00
Amy
Socks
8.95
...
0
votes
1
answer
203
views
Why is Google Sheets query not suppressing header, when there's a calculated field?
I do a simple query on this table,
Row 1
Row 2
Row 3
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
with a calculated column (it is a column that does not exist in the Spreadsheet with the fixed "C" ...
- 15
1
vote
2
answers
346
views
Google Sheets: How to auto split a data set in half to create a control and test group based on a column variable?
I am looking to split a data set in half (consisting of 1000's rows) automatically as the same action needs to be done daily. The difficulty is that I need each Slot start time segment to be halved ...
- 13
0
votes
2
answers
877
views
Find unique count using query function in google sheets
I have 3 columns: date, user & total with multiple rows for the same date. I am using the query function to derive date wise total and unique count of the names but i am not able to count the ...
- 11
0
votes
1
answer
212
views
Link to a google sheets value
Background
I have a google sheet to which I regularly add rows. Each row has an identifier column that remains constant (e.g. the row's "Title"). Rows change positions as I sort the ...
- 467
0
votes
1
answer
435
views
Read Google Sheet Exported JSON by column name in Apps Script
I'm exploring the use of JSON exported Google Sheets as database for Apps Script.
The fetched url follows the structure:
https://docs.google.com/spreadsheets/d/DOCUMENTID/gviz/tq?tqx=out:json&gid=...
- 93
0
votes
1
answer
107
views
Advance search in Google Sheets
Need to accomplish below task, not getting any suitable work around, pls help.
Data as below
A | B |
1 SAM 24
2 John 32
3 Jose 34
4 Samsung 36
I have created a search box using ...
- 87
1
vote
1
answer
223
views
Googlesheets count single cell across multiple sheets
Looking for a formula that will count the value of a single cell across multiple (a whole class of students) sheets. I am aware of using + to do this but for 30 students I'd want something more ...
- 109
-1
votes
1
answer
47
views
I need to get the answer that is 1 above my query search
I have an equation that goes into a column and searches for the first 0, the column tracks the progress of things in 1s and 0s, problem is that setting it to find 1 only returns the top most value, I ...
- 7