How to create custom functions in Google sheets

Title:s

In this video, I'm going to show you how to create your own or user-defined function(UDF) in google sheets with autocomplete functionality using google apps script.

Google sheets already have thousands of built-in functions but if that doesn't work for your logic then you can create your customized function for the google sheet.

***Steps for Creating custom function****

1)Open google sheets
2)Go to Tools- Script Editor and script editor window will be opened in new tab.

****Syntax for Custom function****

function funtionName(input1, input2)

{
return output;
}

****How to use custom function****
1)Go to the cell where you want to use this UDF
2)Type = followed by the function name and given the input inside the parenthesis and press enter.

Note: To enable autocomplete feature, you have to use the tag name @customfunction ahead of function.

********** Tutorial Playlists **********

****** Contact me ********

******* Books written by me ********

******* Productivity tool *********

******* Gear Used To Shoot This Video ******
_Audio & Microphone

********Learning partner********

[urasoran]

Finally, the one place that mentions the @customFunction comment that is needed

[KhuramImtiaz]

Hi great video, when i try to replicate this UDF, the cell where i insert the function gives ERROR and says I dont have permission. How can I get around it? Thank you.