A collection of Google Sheet functions
- Open Google Script editor by clicking on
Tools -> Script Editor
- Copy the source code of whichever function you like to use (files ending in
*.gs
) and paste directly into Google Scripts editor. - Check the code to make sure they are running on the name of the sheet you like to target
- Done!
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);