All Questions
3 questions
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
322
views
How to select the column has value other than the header in google sheets?
I got responses from Google form into Google Spreadsheet. I want to filter out the "Weekend" and "Workday". For the "Weekend" days, I only want to select the columns that ...
- 1
1
vote
1
answer
5k
views
Multiple dependent drop-down lists in google sheets without script [closed]
I work with G sheets in various contexts and this is a pretty frequent use case.
In this case, let's say the spreadsheet looks like this:
https://docs.google.com/spreadsheets/d/...
- 11