Google-App-Script-Files

Compilation of App Script Files used mainly for Productivity Boosts

Sheets

To use scripts/macros on Google Sheets:

1. Open a Google Sheets File
2. Click on Extensions > Apps Script (A separate tab will appear)
3. Write or paste your code
4. Go Back to the Sheets File
5. Import the script via Extensions > Macros > Import Macros
6. Find that function and press the 'Import Button'
7. Open Extensions > Macros > Manage Macros
8. Bind your function to a selected number (from 0 to 9)
9. Test is the function Works (Ctrl + Alt + Shift + )

Scripts

Script	Function
InsertCurrentDate.gs	Use to quickly add the current Date to a Selected Cell
clearRangeToZero.gs	Replaces all non-empty cell values in a fixed range with the number 0.
sumAllToClipboard.gs	Use to quickly total all highlighted cells that only have numerical values. The result is then displayed, which can be copied.