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
My goal is to write a script in Google Sheets that will copy two (or more) values from specific cells on a single row on a worksheet to the bottom of the list o
I have some code to export some output to a Google Sheet. The command I am using for that is: row = [timestamp, float(temperature), float(humidity), current_tem