In google sheets what's the syntax to pull from another sheet, a line item that contains #N/A in a column? I am writing the script on tab1 and the data I am pul
I've been trying to save this macro but I get the error message at line 29. However, everything looks right to me? I cannot understand how to get rid of the err
Want to fetch Google Drive File path, by exact File Name search with Extension and update in other column "Drive File Path" function onOpen() { let menu = Sp
I want to send multiple data using chrome extension into Google spreadsheet. I tried using loop but sometimes it's replacing the data in the current process. I
I'm trying to create custom column in google sheets with query function. for instance (in order to be simple) - I have this data. and the result should look li
I got a Apps Script (onEdit) running, that locks certain cells when a particular time is over, and it also makes a time stamp. The script works perfectly, but o
Google sheet stock inventory Hello everyone, I'm turning to you because I can't get my code to work on google Sheets. The purpose of the program is to be able t
I have this Google sheet where 2 columns are present. Based on a drop down (of list of first column), I have used a vloopup to find corresponding values in seco
If i mark and select 5 rows in google sheet. I want to retrieve an array of retrieved rows. Particully column (0). function selectRow() { var sheet = Spreadsh
Im not an expert at excel/sheets. I wanted to make a dynamic function that would stop user error by doing all of the work. The function basically uses regex to
I am using Google Apps Script to check and re-format date data from some Google Sheets. But the problem is the result shows the times for the user who run the c
I have a sheet with a table with content in the range B6:Y1000. I would like a script that would delete all rows if column C-D-E-F-G are empty
As of a couple of weeks now, I'm getting a "Service error: Spreadsheets" error when running a script in Google Sheets. Before that, it was working fine. It's su
I have a block of html text from which I need to extract the link texts. The HTML code is <li><span class="jkey-title">Job Field</span> <sp
I need some help regarding Google sheets and SUMIF instruction. I have a table where I collect some inputs from a form. I contains a date, name and value. Now I
I need some help regarding Google sheets and SUMIF instruction. I have a table where I collect some inputs from a form. I contains a date, name and value. Now I
so I have a spreadsheet with name, email and phone number now I'm using another service to verify those emails but the problem is that the software is returning
How can I highlight Partial matches in a single column of google sheets? some entries are the same but they have slight misspellings or some are in lowercase. H
I have this table with data below and need help because I don't know which formula can I use to convert the table into the desired one. I don'
I have a google sheets document that has a main sheet which will have columns x y and z and subsequent sheets 1, 2, and 3 that will each also have columns x y a