All Questions
Tagged with gs-conditional-formatting or google-sheets
56,863 questions
2
votes
2
answers
61
views
How do you use an array formula to count the number of times SO FAR a value appears in the array up to where the value is in the array?
I'm trying to use an array formula in Google Sheets in order to get how many times so far in an array a value has appeared. Specifically, I'm using an "array" of single upper case letters (...
- 25
0
votes
0
answers
38
views
Read public gsheet with python [closed]
I am trying to get the data of the 1st sheet of this gsheet in python :
https://docs.google.com/spreadsheets/d/e/2PACX-1vTN03UvJDm99byA6vQPZHKOCYVvfxLu1zkJAzdaKyROykzEKY2-Xl1rl1q5znZEf36m88dxMKsY2eaO/...
- 1
1
vote
1
answer
47
views
How to extract multiple matched columns
I can extract matched columns using the FILTER function in Google Sheets, but I need help making it work when there are multiple matches. For example, if the header row contains the same value in ...
- 611
-1
votes
0
answers
38
views
GOOGLE SHEETS / Join tables, QUERY and data merge [closed]
I have the following datas in different columns, as shown in the exemple file (link below).
https://docs.google.com/spreadsheets/d/19X4lGYywmlX5mP7WeJ_0slDtDIX9c8D1py2CLnjyaFc/edit?usp=sharing
...
0
votes
1
answer
45
views
breakglass/elevated permissions? [closed]
I have a script which applies protection (ie, performs a .removeEditors) via an installed trigger to a sheet row depending on some user input. There is a possible use case whereby the user (not the ...
- 119
0
votes
0
answers
39
views
copyTo Error: Exception: The parameters (SpreadsheetApp.Range,number,(class)) don't match the method signature for SpreadsheetApp.Range.copyTo
I have a spreadsheet from last year and it worked OK then. Without edits, I opened it and now it throws this execution error:
Exception: The parameters (SpreadsheetApp.Range,number,(class)) don't ...
- 1,761
0
votes
1
answer
72
views
How to repeat a series of rows, changing their shared date?
I'm using an app called OneUp to schedule social media posts, and trying to set up a google sheet (here's their page on that) to bulk schedule.
Right now what I have (simplified for clarity) is ...
-5
votes
0
answers
35
views
How to access the Google Sheets API from gspread for functionality missing from gspread [closed]
I want to do some Google Sheet manipulation that is not exposed by gspread. Specifically I want to update the Data Range of a chart.
Given that gspread does not have any support for charts, I ...
- 140
0
votes
0
answers
47
views
google sheets API only returning single chart
I have a little program that is supposed to return all of the charts in a Google Sheets document. The program is as follows:
from google.oauth2.credentials import Credentials
from ...
- 140
0
votes
0
answers
45
views
Unable to open the file at present [closed]
I have a problem. I built a web application using Google Apps Script, linked to a spreadsheet. All the functions I run are working, all the pages are loading, except for two form submission functions. ...
1
vote
1
answer
85
views
Google Sheets script - slow running
I have the following code to copy the last row (effectively used as a template) and paste it a user-defined number of times into the sheet, effectively inserting new rows:
function InsertNewRows() {
...
- 119
1
vote
1
answer
54
views
Google Sheets script .protect() working intermittently
Depending upon a specific input in a set of cells on my Google Sheet, I want to be able to freeze a particular row and stop it being updated.
I have the following script:
function testFreeze() {
...
- 119
-3
votes
2
answers
170
views
How can I stack each 3 sets of 4 rows? [closed]
I have a report that vertically stacks yearly data made of two columns:
The first column shows the year and each of its 4 quarters (format: "YYYY Qx").
The second column shows a $ amount.
...
- 47
0
votes
0
answers
41
views
Gmail API 403 "Delegation denied" error using Service Account DWD (Apps Script) despite Super Admin role
I am running a Google Apps Script to programmatically update Gmail signatures for users across my Google Workspace domain using a Service Account with Domain-Wide Delegation (DWD).
Despite confirming ...
- 53
-1
votes
1
answer
57
views
How to count NULL values in Looker Studio when using a date range filter (using DS_START_DATE / DS_END_DATE parameters)
I’m working in Looker Studio (Google Data Studio) using a Google Sheet as my data source.
My dataset looks like this:
Each merchant can have multiple shipments (or none).
I have a date range control ...
- 29