Posts tagged with: custom-functions

Using ARRAYFORMULA with Custom Functions

Learn how to use ARRAYFORMULA with custom functions in Google Sheets to process entire columns efficiently

Enable autocomplete for custom functions in Google Sheets using JSDoc

Learn how to enable autocomplete for your custom functions when you use them within formulas in Google Sheets.

Create a Custom Function to Identify Email Providers in Google Sheets

Learn how to create a custom function in Google Sheets that automatically identifies the email provider (Gmail, Microsoft 365, etc.) from any email address.

How to convert strings to Proper case in Apps Script?

In this tutorial, you'll learn how to write a custom function to convert a string to Proper case in Google Apps Script.

How to get the Hexadecimal codes of colors in Google Sheets

Learn how to write a custom function to get the HTML color code (also known as a Hex code) of a cell's background color.

How to pass cell coordinates to a custom function?

Learn how to make your custom function know which cell it is being run from.

How to return an error from a custom function?

Learn how to use the throw statement to inform users that an error has occurred in a custom function.

Returning values from custom functions in Google Sheets

In this tutorial, I'll describe how to return values, errors and arrays from a custom function.

Star rating system in Google Sheets

Learn how to build a 5-star rating system in Google Sheets using a custom function written with Google Apps Script.

Custom functions for Google Sheets using Apps Script

Learn how to write a custom function for Google Sheets using Apps Script.