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
I have attempted to import price data from this site: http://runescape.wikia.com/wiki/Rubber_turkey# with this import xml code: =IMPORTXML("http://runescape.
I am working on a google apps script web app to get it to poll a google sheet for changes/updates. At the moment this can either be "content" or simply when the
[Edited to include a minimal reproducible example as suggested by T.J. Crowder.] I'm working on a simple function using Google Apps Script that is supposed to
I have found code for a basic 2 column Cartesian join but I have a slightly different situation. There are 3 Variables/Columns: Color, Color ID, & Item. I'd
I have 2 google Forms. User fills either of the google forms and it populates 2 "active" tabs within the same sheet to record user responses. I would like to us
Sample Table Date Created (A) Tracking ID (B) 5/12/2022 '813vz633-7872' 5/12/2022 '914bz756-7423' 5/12/2022 '875vu340-5687' 5/11/2022 '475dv235-6542' 5/11/2022
Sample Table Date Created (A) Tracking ID (B) 5/12/2022 '813vz633-7872' 5/12/2022 '914bz756-7423' 5/12/2022 '875vu340-5687' 5/11/2022 '475dv235-6542' 5/11/2022
Here is the spreadsheet of data and desired result: https://docs.google.com/spreadsheets/d/13tXrlZQK0bXlA2EhGA-CJEXAEdfxyvAWvqwflqty-GA/edit?usp=sharing Basical
I am trying to produce a "reverse pivot" function. I have searched long and hard for such a function, but cannot find one that is already out there. I have a su
I am using the following Google Sheets formula to translate some fields containing HTML tags: =GOOGLETRANSLATE(A2, "en", "de") However, the translation resul