I'm Thomas and pretty new to appscript. I managed to use it in order to translate cells in a google sheet using DeepL API. I did it thanks to this post : https:
I've just learnt about arrayformula and continue for keeping formulas into new rows, now im trying to get a single string to copy into new rows "N". How can I a
I have a problem with my code. It seems fine but it doesn't work and I really don't know why. I tried everything. I want sync my google excel with my google c
Is that possible to change pivot table totals row location in Google Sheets so that they display directly under the pivot headers? I have browsed the available
Is that possible to change pivot table totals row location in Google Sheets so that they display directly under the pivot headers? I have browsed the available
enter image description here I want to import data from a table within an HTML page. Used IMPORTHTML =IMPORTHTML("https://www.fpi.nsdl.co.in/web/Reports/FPI_For
On sheets, I'm using this formula to sum hours to a specific month from a drop-down menu. =QUERY('Form responses 1'!H2:L, "Select L, Sum(K) WHERE L is not NUL
In google sheet I have 2 ranges of variable length with some data,i.e. column A: aa, ab, ac; and column B: ba, bb, bc. I would like to combine them in one lon
I have a column XXX like this : XXXA Aruin AvolynB Batracia Buna ...I would like to count a cell only if the string in the cell has a length > 1. How to do
The spreadsheet has some cells with cell contents that are separated by commas, or a new line. 123, 876, 456 Column "C" is the column that determines whet
The spreadsheet has some cells with cell contents that are separated by commas, or a new line. 123, 876, 456 Column "C" is the column that determines whet
Good Day! I would like the Purchase Order ID repeated upon submission of a form in an earlier sheet. My current code however repeats this throughout the length
I am trying to show an alert popup when cell selection is changed, using the new trigger onSelectionChange. For some reason it is not showing any alerts. Am i d
Looking for some help please, I've been tinkering with the code now most of the day and im stuck, and this seems about the best solution I have found so far. I'
When creating a spreadsheet ex novo, Google's SpreadsheetApp allows one to specify the number of rows and columns of said spreadsheet: var spreadsheet = Spread
I have on Google sheets this data (It is the same principle in excel). I want to count the numbers of dose in each strings. I use this formula and it return me
I'm trying to get data from Google Finance in Google Sheets with this formula: =GoogleFinance("CURRENCY:BTC") But I'm getting this error: GOOGLEFINANCE, the
I'm not sure where to post this question but I thought here would be a good spot. What would be a Google Sheets formula to see if I am on track to stay within m
I have a Google Apps Script custom function, very simple: function sharesBurned(sharesToSell) { return "tree" } Obviously, this works when I test it in
I am wondering if you can point me to an example of reading/writing to/from a google doc/spreadsheet using python. I did look at google docs API here https://