I've been working on a dashboard in Google Sheets and want to be able to do the following: When I...
If I use callbacks, the code below using Google's Sheets API v4 works fine. However, I am trying...
We have a base sheet as shown here. This is the place where this info needs to be edited by our...
I am trying to make column 8 display timestamp when column 7 value changes. However, my column 7 is...
In my git repo there many csv files. I dont use any editor on my mac but rather use google sheets...
Update: I wrote for loops to fix the merged cell and column width issues. Just need some help with...
There are two columns N and O. When any cell in column N is filled the adjoining cell in column...
I have a script where a user inputs some information on the user tab. Then, they hit a button...
I have a Google Sheet with an onEdit trigger running Google Apps Script code to add cell range...
I'd like to write a formula for multiple IF conditions that will show in my cell S23. IF: H23=...
I'm trying to create an automation script with php which adds a new row of information to a google...
iam working with...
I am writing a google app script which converts a string to UTF-16 unicode format. For example...
First of all: I am new to the whole programming-thing. Because of starting a small company - a...
not sure if I can insert script parts from Google's Chart Service into Google Spread Script but I...
I want to make 'onedit' work only on the sheet whose value is changed. eg.) [sheet1] If you put a...
So, I never ever programmed JavaScript and never did anything with Google Script before either. I...
My script below returns 'undefined' to the Google Sheet when I add dfStatus.error.count to the...
If I have cell A1 with value 73562 How can I split it so that I create an array that I can then...
I have a spreadsheet with a column for DOB. However, the age should be over 18 years from today....
I want to add 2 formulas in one cell on Google Sheets but for some reason I keep getting an error...
I get this date format from Zapier 2018-08-16T01:13:58 I use this formula to split and extract...
I'm trying to export PDF from Google Sheets via Apps Script. I've found useful code online, which...
I am trying to have an app script that will put an image from an online url into a cell on my...
Is it possible to get a range that is calculated from a formula? For...
If i have a string like abc_xyz, i can use =REGEXEXTRACT(B2, "(.*)_") to extract abc from it. But...
I would like to loop the following macro every 15 minutes in the background. function _1() { ...
First, my apologies for a lousy (but accurate) title. I'm trying to take the value of cell AB9 and...
I was wondering if I can move a function automatically while the cell value remains the same. For...
I have data in this format and I need it to be reformatted into this. Basically, each row in the...