Please, help. I can't find the error and I don't understand why the request is not working. It seems to me that it's just Google's IP blocked by the site I'm ma
I have 3 sheets in a workbook - Sheet1, Sheet2, and Sheet3, every time I change to a Sheet there is a Popup message that will show up. What I
I've made a simple table in a one of many sheets in a google sheet file and I would like a cell range of a sheet to alway appear upper case no mater what user i
I am new to Apps Script, but I have a code that fills form data in to a spreadsheet. It's working fine, but I want to make a hyperlink using the coordinates fil
I am trying to copy the content of a single column and send this range of data in an email. My users submit a for. Their email address are added in column C. I
Problem: wrong time and timezone .getValue() from cell with format timeThe bug occurs in old spreadsheets from 2017, but not a spreadsheet from 2022 january or
Hi I'm very new to coding with Google Sheets and Excel. My goal is to move a row when it is checked off. The original sheet is called "School Assignments" and t
I need to rename image files in a Google Drive folder I have a Google Sheet with 2 columns, old name and new name I would like to rename the files within the sa
In the following script I have to manually insert the email addresses. I rather get the list from the sheet to be able to update it without editing the script.
I have this script below that imports data automatically from several sheets via a master sheet that has a list of sheet IDs. I would like the data to be auto s
I use a script that allows me to delete the empty rows in the middle of my table and also constantly adds rows at the bottom so that I can keep filling it. Ever
I'm looking to improve my array push inside loops but I noticed that every time my function is being called (in a loop manner) and executing this lines of code,
What is the most efficient way with google script to build a range (newRange) from another range (baseRange) based on some criteria (e.g. the formula contains '
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 convert a date like this dd/mm/yyyy to numeric format but I don't find any way to do this in google app script For example I have a date in my "L2" ce
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 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'm trying to build a custom range for this sort function in an Apps Script for Google Sheets but I keep getting the error: "Exception: Range not found; sortPro