2
votes
Accepted
Formatting dates based on year
The following code writes all formats in a sheet in one go which is faster than writing values one by one. It skips hidden sheets and detects protected sheets where the account that runs the script ...
2
votes
Accepted
Recorded a Macro to Import a File in Google Sheets
The Google Sheets macro recorder writes a JavaScript function using Google Apps Script classes. Only some Google Sheets user interface commands are available on Google Apps Script. File > Import is ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
google-apps-script × 1807google-sheets × 1529
google-apps-script-triggers × 136
google-forms × 122
formulas × 94
google-docs × 91
google-sheets-timestamp × 77
google-drive × 72
google-sheets-custom-function × 69
google-workspace × 61
gmail × 54
javascript × 48
google-sheets-query × 30
google-sheets-arrayformula × 25
sorting × 20
conditional-formatting × 19
google-calendar × 18
importrange × 17
google-sheets-dates × 15
google-sheets-macro × 14
google-apps-script-add-on × 13
automation × 12
data-validation × 12
google-contacts × 11
date × 11