Home » Spreadsheet Script

Google Spreadsheet Script Missed Tasks

Google Spreadsheet Script Description A fellow Google Docs user had the following use case: I have a spreadsheet with daily, weekly, and monthly tasks for the whole year. If the task is ‘Met’ on time the user selects…

Read More »

Install Google Apps Script HTML Service

google apps script HTML service

How to install a Google Apps Script HTML Service script in the script editor. Description: This post is a general guide on how to┬áinstall a scrip that uses the Google Apps Script HTML Service. Install Script: 1. Firstly,…

Read More »

Google Apps Script Weekly Task Reminders

I want to run the script so that everyone gets a reminder about all tasks in the sheet that are assigned to them via email. Description Google Apps Script Weekly Task Reminders script sends out reminders to task…

Read More »

Google Apps Script Removing Commas

Google Apps Script Removing Commas Removing commas from form submissions can be tricky. Certain question types can save the responses in a 1,2,3,4 type format. If you find that you want to remove the commas for each submission…

Read More »

Google Sheets Sort by Timestamp When Opening

Google Sheets Sort: You automatically want Google Sheets to sort by time stamp when you open it up. Sometimes when you are working in your Google Forms response sheet things can get out of order. If your lazy…

Read More »