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
I am trying to write a formula that will take a set of columns and pair them into separate rows with a comma-delimited list. In SQL, I would do this with a left
I tried to take a code and adapt it to my needs but without success as I am new in script. This code allows to generate a google map with markers on several add
Started getting below error randomly. while same code works fine if I stop my service and sun again. but after 1 days or two its start giving this error. I have
I need help, I'm using an onEdit function to implement data validation based on a sheet. It is working fine when I use it alone. I can choose a type in Colonne