Skip to content Skip to sidebar Skip to footer
Showing posts with the label Google Sheets

Automatically Locking A Range (column) As Each Date Passes?

I have a sheet that employees will update daily with information about tasks done that day. Each co… Read more Automatically Locking A Range (column) As Each Date Passes?

How To Send A Notification Based On Changed Cell On Google Spreadsheet

I know it is similar to email notification if cell is changed but I would like to do the following… Read more How To Send A Notification Based On Changed Cell On Google Spreadsheet

Google Sheets - Moving Row To Another Sheet Based On Specific Column

Very new to the Google Sheets script editing, but I'm trying to move rows between sheets. I'… Read more Google Sheets - Moving Row To Another Sheet Based On Specific Column

Getting Value Of A Cell From Google Docs Spreadsheet Into Javascript

I have a javascript function function calculate() { var interestRate=4.5; ... } I would like … Read more Getting Value Of A Cell From Google Docs Spreadsheet Into Javascript

Hiding Worksheets From Specific Users Inside A Spreadsheet

Sorry I'm not familiar with coding, I have a spreadsheet with multiple worksheets, it's sha… Read more Hiding Worksheets From Specific Users Inside A Spreadsheet

Unhandled Exceptions In Google Apps Script

I have created a public Web App with access to my private spreadsheet data. I can catch and log exc… Read more Unhandled Exceptions In Google Apps Script

Google Form + Apps Script Onedit

So, I have a Google Form that outputs the data to a Spreadsheet. I have written some code for the o… Read more Google Form + Apps Script Onedit

Use Google Apps Script To Loop Through The Whole Column

I am trying to loop through the whole row in my google sheet and copy some of the data from one she… Read more Use Google Apps Script To Loop Through The Whole Column