I want to pre-process my data like the Result section of the attached image before flattening and using it. I want to write an array formula in the cells marked
EDIT*** Modified the question now that I have a proper source... I am trying to copy a communication log to Google Sheets and don't know enough about scripting
After some searching I found this code to get a sidebar of all tabs (workbooks) in Google Sheets as a hyperlink. I am looking to add two functionalities to this
I'm trying do create a master sheet for work, as for nom we work in the middle age, copying some data to up to 4 differents documents and I want that to change
In Google Sheets, is there a way to calculate the width, in pixels, of a piece of text given a font and a font size? Excel has a PixelWidth function, but I didn
I am trying to figure out the official code sample of Google: /** * The event handler triggered when the selection changes in the spreadsheet. * @param {Event
I want to add values in Column C with the conditions that Column B = 0, AND Column A = "a" OR "b" From what I've searched, this would work, but only in excel:
I am using the IMPORTHTML function in a Google Sheet cell to import commodities performance table from website : https://www.investing.com/commodities/real-time
I'm using this script I found and it's working fine in inserting a new row, I just add a new line to clear the row clearContent(). I wanted to modify this so th
I'm trying to link a table from a google sheet to a google presentation. I'm normally presented with a dialog asking me whether I want to link the spreadsheet
I am trying to run the code of this post, : Google Script: Play Sound when a specific cell change the Value with the recommendation of Rob Blakemore Could some
I found out that you can't use an array formula if you are using the "if" "and" "or" formula on google spreadsheet. Can someone please help me fix this formula
I am a newbie on importxml and trying to scrape the property agent information from a website, I did success to get the required field from the page, but:- Ther
The grey chart borders show up, no matter what you do in Google sheets, when converted into PDF. Is there any other way or script to make it hide while PDF conv
I have mild general programming knowledge but know basically nothing about google apps scripts specifically. I am trying to create dynamic page breaks in googl
Example Spreadsheet Current formula not returning values as desired: =IFERROR(ifNA(min(arrayformula(index(D2:I2, match(INDEX(FLATTEN(split(A2, ", ", FALSE)&
Protecting a range in google sheet also locks the cell's column width. I would like to make a cell read-only but still allow the user to resize the column widt
I'm trying to scrape the votes from SofaScore with google sheets using the importxml function. I'm running into an issue because the class name has a random str
I'm trying to get the values for column C in Table 1 from column H by using vlookup. However, seems like the vlookup doesn't work and return a N/A. I had check
I am getting this error on my query. Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC I don't understand whats the problem is