Skip to content
Advertisement

Tag: google-sheets

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

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

Advertisement