All Questions
Tagged with google-apps-script google-sheets-formula
1,596 questions
0
votes
1
answer
63
views
Using IMPORTXML to scrape dropdown data from webpage into Google Sheets
I am not well versed in using advanced datascraping and coding. However, there is a webpage ("https://www.ksestocks.com/HistoryHighLow") which carries a dropdown menu with various options. I ...
0
votes
1
answer
67
views
Tether workbook copies to a master copy. Updates to copies filtered according to a key
I have a master and multiple copies of a sheets workbook. I would like to update the master and have the copies update AND filter the update according to a specified name/id value.
I have used the ...
0
votes
2
answers
124
views
Match data based on id between sheets of one googlesheet &extract alphanumeric values in separate column
I am working on google sheet which has 3 sheets Deposit report sheet(10000 rows) , payment sheet which was actually .CSV file (26000 rows) and output sheet which will show output by appscript in which ...
- 71
0
votes
1
answer
142
views
Auto numbering rows in GoogleSheet
I want to create an auto-number for each row in my google sheet following the logic below:
it takes the sheet number from A1 e.g. 8
generates sequential table header numbers from that sheet number ...
- 1
0
votes
0
answers
122
views
Using ImportXML to import info from a website into Google Sheets [duplicate]
Trying to import the Lottery Jackpots into google sheets, doesn't seem to be working.
Specifically I want the amounts for the following lotteries:
LottoMax (including # max millions) - Currently 60m ...
- 11
-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
0
answers
38
views
Is it possible to update (add/edit/delete) named functions using apps script [duplicate]
Context
We have a master template and many users using copies of it in their accounts.
I'm using apps script to update users sheets to new version, once we make changes to master template spreadsheet.
...
- 1,580
0
votes
2
answers
144
views
FLATTEN output from ARRAYFORMULA with TRANSPOSE/SPLIT/VLOOKUP
I'm attempting to create a spreadsheet to provide a visual representation of a server rack. I have a server named range with rack# and Rack Unit (RU) location of the server within that rack. The ...
- 11
1
vote
1
answer
81
views
how to construct and write a formula to google sheets to perform a dynamic date calculation
I will be importing data in a spreadsheet form from my database software. I am wanting to be able to take my cell that has a date of birth in MM/DD/YY format and through Google script make a formula ...
- 13
0
votes
2
answers
77
views
Clear active sheet without clearing formulas or Letters
I have written this script to clear data and keep formulas, however I would like to keep
the letters. IE column titles I have made so that when I enter data I know where it goes.
This is my current ...
0
votes
1
answer
74
views
Can I find the value of a cell B49 that changes value according to the value of the cell F2 ( in Google sheet)
Let in a google sheet all cell changes value according to F2 cell whose value can be 1,2,3,4,5,6,7,8,9,10,11. Now write a formula to find the value of B49 cell when F2=1. The formula should work on ...
0
votes
1
answer
70
views
Filter data using multiple sets of checkboxes to determine the criteria
I am trying filter data using multiple sets of checkboxes to determine the criteria.
Here is the spreadsheet I am working on. Here are some notes about each sheet:
Dashboard: I have four sets of ...
0
votes
1
answer
77
views
Google Script To Copy row based on Drop down, Not working
I am trying to copy the entire row (From the calls tab) if certain items are selected in the J column. Basically if any of the items are selected in the drop down menu of the J column except "...
1
vote
1
answer
63
views
Rank based on which column is being sorted by in a Table
I have the following columns in a Google Sheets Table. In column A, I have the rank column.
I would like to have the rank value be based on whatever column is currently being sorted by. In this case, ...
- 2,935
1
vote
0
answers
102
views
Is there a way to generate the authorization url for the importdata function to run?
I have a script set up to generate a spreadsheet we use when a new file is created in a particular folder. It uses the importdata() function in google sheets.
Recently google sheets updated their ...
- 575