I use a script that allows me to lock a row if in the “BG” column I put an “X”. I would like that if I put a “0” then the protection is removed. Also add a function so that the script runs automatically when I change the value in the “BG” cell. My Script: Answer Instead of looping through
Tag: google-sheets
Google Sheets google apps script add a VLOOKUP function for all rows
I have a sheet with a number of VLOOKUPS which do work BUT whenever a new row is added the VLOOKUP formula is not added to the new row. I’m certain this can be done with app script but I don’t know exactly where to start. It is important (OK vital) that the VLOOKUPs are on every row even new
Deleting Data In Bulk – Google sheets
I found this piece of code and need to modify it so that if it doesn’t find a result it will return and keep running next lines of code So if it doesn’t find “JOHN” it currently stops running and throws an error. I would like it to move onto next piece of code if no result found. appreciate any
How to speed up surprisingly slow Google Sheets Apps Script functions that copy formulas from one column to newly inserted column
I have a workbook with multiple sheets, and the main sheet has 123 rows and 90 columns currently. I’ve coded the following functions (which work) to define an onChange event handler for the INSERT_COLUMN event that automatically populates the cells of the newly-inserted column with the contents of the column immediately to the left. Then it deletes the values of
Add a row per day or week automatically for multiple years (w/ using script or function ?)
What I would like to do is to create a script or with a function that will add automatically the day, the month and the year per row for 4 years for example in order to make a calendar of shooting, pre production and post prod per film. It would be so long to do it manually and add each
Wrapper around importdata() in Google Sheets
I am trying to write a wrapper around Google Sheets’ importdata() in code.gs: The idea is to call the function from any sheet in the spreadsheet to get the price of any crypto currency token: I get an error though when I try this: #ERROR Exception: You do not have permission to perform that action. (line 102). Why is this
How to display values from google script object in html ?
HTML code I want to display object values in this form in <p or easier solutions GOOGLE SCRIPT code function findId returns row number by typed id Answer In your situation, how about the following modification? HTML & Javascript side: From To: Google Apps Script side: From To: Note: From <p id=”serial”>result</p>, I guessed that you might have wanted to
App Script new Google Sheet creation issue
I am trying to write an App Script that takes string data from multiple different spreadsheets (completely separate documents) and puts them all in a new spreadsheet. When I run the logger, it shows me all the data I want. I want each piece of data to show up in Column A, but when I run my script, it only
Parsing JSON into Google spreadsheet (Apps Script)
I have a download in JSON format that I get through the API. Example: An example of what should happen: enter image description here The ratio of the JSON list of employees with columns in the table: How can I convert JSON to a Google spreadsheet for 300+ rows? At the moment I only have a request to the API.
Set a range to uppercase in sheets APP SCRIPT
I want to create a script that I will have in a menu that gets the range “A1:C” and uppercases it. The problem is that throws an error “TypeError: values.toUpperCase is not a function” trying to use toUpperCase(). Got the following code: Im pretty new to JS and sheets api. I feel dumb because it looks like something simple. EDIT