/sheet-functions

A collection of Google Sheet functions

Primary LanguageJavaScriptMIT LicenseMIT

sheet-functions

A collection of Google Sheet functions

Installation

  1. Open Google Script editor by clicking on Tools -> Script Editor Click on Tools -> Script Editor
  2. Copy the source code of whichever function you like to use (files ending in *.gs) and paste directly into Google Scripts editor.
  3. Check the code to make sure they are running on the name of the sheet you like to target
  4. Done!

Time Updater

The time-updater.gs script will record the date, time and user's e-mail address on two consecutive pre-defined cells. You can modify which cells by modifying this portion of the script:

SpreadsheetApp.getActiveSheet().getRange("C1:C1").setValue(timestring);
SpreadsheetApp.getActiveSheet().getRange("D1:D1").setValue(userstring);