google-sheets Questions
4
Suppose I have a long, unordered, and gradually growing column that I search the even numbers from.
=filter(A1:A,ISEVEN(A1:A)=TRUE)
Now I would like to reverse this result, so that the last even n...
Gumshoe asked 30/7, 2020 at 18:50
6
Solved
In Google Sheets, how do I get the value of the first non-empty cell in the row 17 starting at column C forwards?
Withhold asked 9/5, 2020 at 2:11
4
Solved
How do I make the variable "Partnum" not be case sensitive. When I run the script, it wont detect "aBcd" if I'm searching for "abcd" . I'm not sure what to do.
function doStuff() {
var ss = Spre...
Yser asked 6/12, 2010 at 23:47
4
I’m stuck trying to create a Google Sheets formula that searches a range for a value, and when the value is found returns the value of column a on the row where the value is found.
Ie: my range is ...
Yarmouth asked 16/9, 2023 at 9:23
2
Solved
In Google Sheets, using formulae, is there a way I can search for a certain string in a certain sheet, and return the reference of the cell which contains that string?
The string would be unique to...
Drome asked 5/9, 2020 at 9:59
3
Solved
GAS is quite powerful and you could write a full fledged web-app using a Google Sheet as the DB back-end. There are many reasons not to do this but I figure in some cases it is okay.
I think the bi...
Noah asked 24/6, 2019 at 13:31
12
Solved
I downloaded a Google Sheets workbook as a CSV file and tried to import it as a table in my MySQL Workbench, but I keep getting this error...
Unhandled exception: 'ascii' codec can't decode byte 0x...
Debouchment asked 24/4, 2022 at 20:42
7
I am trying to develop an application, where I where fetching data from multiple clients related to some transactions. Now I want to make some analysis using the Google Spreadsheet. Is there any wa...
Mcclintock asked 22/1, 2016 at 4:21
3
I'm trying to get a script that I've made for a google sheet to trigger when the sheet is opened (since I've found you can't trigger them manually through the mobile app). Somehow, I've managed to ...
Vasya asked 17/6, 2018 at 6:21
2
Solved
It is possible to set the range border style and color. Now the question is: how can we get the border style programmatically?
I'm looking for something like:
var ss = SpreadsheetApp.getActiveSprea...
Urethroscope asked 12/2, 2018 at 19:41
1
Example: If I set a right border in cell D2, then look at .getBorder().getLeft().getBorderStyle() in D3, there is no border, yet when I clear borders from cell D3, it clears the border that was set...
Heilbronn asked 28/7, 2020 at 0:7
1
Solved
I was trying to get the information about the borders of a range, doing so I tried the getBorders() function, but received the following error:
Exception: Unexpected error while getting the method...
Yon asked 8/8 at 12:20
5
Solved
Simplified scenario:
Sheet Customer_Orders, has blocks of rows with each row having product code, count ordered, and size. Bunch of other stuff is looked up/calculated on the basis of these three ...
Carpel asked 11/11, 2019 at 20:54
5
Solved
I have (what I thought was) a simple lookup table holding some exchange rates. There I am looking up values based on row and column indices.
How can I do that in an ARRAYFORMULA like this?:
=ARRA...
Gatha asked 7/1, 2017 at 22:7
2
Solved
When working in excel, to find the sum of the quotients of corresponding numbers in two sets, you use a function as follows:
=SUMPRODUCT(A1:A5 / B1:B5)
In google spreadsheets though, although the...
Rianna asked 13/11, 2013 at 9:2
4
Solved
I am trying to download a Google sheet via a batch file. This works:
powershell -Command "Invoke-WebRequest https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/export?exportFormat=tsv -OutFile o...
Kemme asked 28/2, 2019 at 1:40
8
Solved
I'm trying to pass an object (contents of a sheet row) to an apps script template. You can see the row in the screenshot.
my function in apps script contains:
var sendableRows = rows.filter(fun...
Equipoise asked 18/2, 2019 at 14:28
5
Solved
It is possible to add a "link" to a cell in a google spreadsheet through the user interface. I want to do the same using a Google Apps Script. I was expecting there to be a method on the Range clas...
Finkle asked 27/5, 2016 at 14:25
3
Solved
Sometimes I come up with long spreadsheet formulas, such as this one to create "data bars" using Unicode characters (addresses are relative to G3):
= rept("█"; floor(10 * F3 / max(F$1:F$999)))
&a...
Dorotheadorothee asked 21/7, 2016 at 15:14
5
I have a sheet with a line chart, now I'm trying to do something maybe very simple: I would like to add to this chart a vertical line using a value in a cell.
So I have this line chart
And a cel...
Pocahontas asked 20/9, 2019 at 10:5
7
Solved
When working with google spreadsheet, how to download all the sheets at once?
I want to use the option:
Comma-separated values
But it only download the current sheet, how to get them all?
Dreadful asked 24/2, 2015 at 21:59
6
I'm trying to generate a random 8 character alphanumeric string in Excel (or Google Sheets or Libreoffice, which both have the same challenge) using a formula. I'd like to get something like this:
...
Prae asked 5/12, 2022 at 21:57
7
Because google spreadsheets does not support iterations, I wrote my own simple app script to adjust an input based upon the calculation of the spreadsheet output. However, after I change the input ...
Alfeus asked 3/10, 2012 at 14:51
3
Solved
There isn't a way to share only one sheet of one spreadsheet in Google Sheets. So, you have to share an entire spreadsheet. So, I was thinking in writing a script to synchronize two sheets (each on...
Swatter asked 7/12, 2013 at 17:9
9
Solved
How to generate an uuid in google sheet (for exemple ccb8a660-91c9-a556-58e0-4fa7-229516872004).
Either with a macro? or a formula?
Episcopal asked 9/7, 2018 at 12:7
1 Next >
© 2022 - 2024 — McMap. All rights reserved.