Description
Create custom functions and macros in Google Sheets with Google Apps Script.
Instructions
Create a custom function
- In Google Drive, open the spreadsheet for your custom function.
- At the top of the spreadsheet, click Tools > Script editor. If you see a welcome screen, click Blank Project.
- Add the code for your custom function or macros.
- Click File > Save and enter a new project name.
- Click OK.
- In Sheets, refresh the spreadsheet that contains your custom function to see your changes.
See sample Sheets functions you can use.