I read an API with Google Sheets and want to get results similarly to this: But the API is a bit strange and puts always a header row into response. With it, the response of the first formula looks like: and the second formula (=MyApiFormula(A3)) doesn’t work at all – sure, because it is forced to write into cells with
Tag: google-sheets-formula
How to send values to automatic sequential rows in an arrayformula on gsheets?
This would be much easier to solve on the 1* data sheet, but I am trying to have grouped data with a weekly quantity broken down into a daily # to make work easier further down the line. =query({…
Is there a way to pair entrys by rows to give pairs such that there is maximum overlap by columns?
Sorry, for the poor phrasing. I am struggling to find a good way to describe this problem, so I will go with an example. Say I have a bunch of people that I need to pair up together based on similarities between rows. If my data looked like something below, how would I go about pairing people up by the
How can I refer to 2 differents dataset into a gsheet query formula?
I’m trying to get a formula to match 2 different data set in google sheets. I did the following but I keep getting “parse error” With D10 is the cell that I’ll look up the match for. Let me know if you have any tips and thanks! Answer The syntax for QUERY is QUERY(data, query, [headers]) In your case, you
Adding sheet name as column to query in Google Sheets
I have a Google Sheets document with my video game collection. Each console system has its own sheet, but I decided to consolidate all sheets into one new sheet as an overview using a query that looks something like this: This works fine, and I’m satisfied with it. However, my collection is quite large and spans over 20 consoles, so