We'll start by going to the Tools menu and clicking Script Editor, where we'll create a new project for our scripts. Now let's create our first custom function, which takes a numeric rating of our day and returns a one-word description of it (e.g. Formulas can be used for calculations such as: 1+1 22 4/22 formulas can take cells as input. Formulas always start with the equal sign () typed in the cell, followed by your calculation. To call a function, just type = and then the function name. A formula in Google Sheets is used to do mathematical calculations. And there are functions that allow you to access Google APIs, like GOOGLEFINANCE, which allows you to include auto-refreshing stock prices in your spreadsheets.Īnd Google Sheets doesn't really care whether a function is built-in or custom - they're called in the same manner. There are mathematical functions like SUM and COUNTUNIQUE, date functions like TODAY (to get today's date) and DAYS (to get the number of days between two dates). Prefer watching a video? Check out my Egghead lesson on this topic!įor those newer to spreadsheets, the concept of functions already exists in the form of built-in functions that you can call. In this post we'll learn how to create custom Google Sheet functions, which are the basis for a lot of this functionality. but I didn't know that you can actually hack the menus, add custom functions, and gain programmatic access to loads of Google functionality.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |