Can I create my own formulas in Google Spreadsheets?

Question

Google Sheets

I always answer questions on the tables, and now I ask you for advice.
I worked up a cool formula, and now it needs to be used in many places. Got a question. Is it possible to make your own formula, give it a name, and use it further?

Answer 1

Yes, you can use Google Apps Script to create so-called custom functions. Please note that formulas from the spreadsheet editor cannot be used in them. Those. instead of ARRAYFORMULA, it will be necessary to traverse the entire array in a loop, etc.
https://developers.google.com/apps-script/guides/s...