JavaScript Info

I'm creating a custom function in Google Sheets to provide the end date for a task based on the… Read more Exceeded Maximum Stack Depth In A Custom Function For Google Sheets

function timestamp() { return new Date() } The function recalculates every-time i open the sheet. … Read more Function Recalculates Every Time I Open The Sheet, I Only Want It To Recalculate On Edit

I am using google sheets where there is a duration value of 69:41:00 where it's 69 hours, 41 mi… Read more How Do I Get The Number Of Days For A Duration Where The Number Of Hours Exceeds 24 In Google Sheets?

I have comma separated lists in a Google Sheet, like 'apple,banana'. I need a function to a… Read more Custom Google Sheets Function To Add An Item To A Comma Delimited List

I am trying to execute a simple Apps script to retrieve data from my google sheet. However, I get t… Read more Bad Value When Trying To Execute Google Apps Script

I would like to use Google SpreadsheetApp to write a 2D array into a sheet. Trying sheet.getRange(s… Read more Spreadsheetapp: Getrange And Setvalues

I have a sheet where column A has dates. I need to get the row number of a block of rows with the s… Read more Get Row Block With Createtextfinder() From Column A With Dates With Same M And Y When Locale Is En_us

I want to merge these two functions below to get the desired output which is the following: Lets as… Read more Merge The Following Regular Function And Onedit Function To Obtain The Desired Result

I am working on a project where I must have daily inventory entered by multiple locations into Goog… Read more Submit Button On Google Sheets

Following this question I had asked previously (Need to Query Google Sheet for specific data from G… Read more Need To Check For Login Username And Password, And Then Bring Data From Previous Entries

so I have a new problem. So far my script here can loop a sheet and find the text 'Bank', i… Read more Google Sheet Script - Multiple Getrange Looping

Ok I'm very new at SO and and reasonably new with JS and Sheets. I am writing a sheet for work … Read more Google Sheets, Running A Function As Owner

Hello Stack Overlords! I'm currently trying to put together a little coding project. Something … Read more Google Scripts Seems To Be Caching Cell Values - Any Way To Avoid?

I'm trying to get the data about XAU prices from table here: https://www.investing.com/currenci… Read more Script To Refresh Data With Importhtml In Google Sheets

I created a new google sheet for collecting user information. In my sheet script editor, I created … Read more How To Auto Populate Form Options Based On A Column In The Attached Spreadsheet

I searched the internet and I can't find a response to this nor the documentation for it. I nee… Read more Import Google Spreadsheet Data Into Google Forms With App Script

I really thought I was starting to understand how this works until I tried to distil a test case fo… Read more Reading And Writing Time Values From/to A Spreadsheet Using Gas

I have a google sheet where there are some functions in the cell like: =CLEAN(SUBSTITUTE(CONCAT… Read more Does Google Sheet Needs To Be Opened For A Function To Run?

I found a script that's supposed to add cell history in a note, the original one found here(htt… Read more How To Fix Cell History In Cell Note?

I have the following lines in my Google App script, but the File API is now deprecated and I am una… Read more Get The Newest File In A Google Drive Folder