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
Here is an example table: A B ------ ---------- 1 | Name | DOB 2 | John | 01/01/2011 3 | Tom | 02/02/2002 I need to return the names of people
I am trying to avoid concurrent process with LockService on my project. In test runs, LockService works for me without any problems. But when I roll my projec
With this script I would to put the CSV in a specific Sheet named "TEST". I have tried with getSheetByName but without result. How could I proceed? function imp
I have a Google Sheets document where I track the prices of several stocks. I made this a couple of months ago, and have been experiencing this issue for the pa
I am using conditional formatting to search a value in a cell and apply it to a specific column. If the data matches it highlights the entire row. The issue I a
I have created a Python script (using Google Colab) and stored it on my Google Drive. When the Python script runs it automatically reads a Google Sheet in the s