How to make a Google Sheet custom function as an Add-On

Question

I'm tying to create a custom function for google sheets that will be accessible with an Add-On to Google Sheets.

The problem is when I run the Add-On as a test, when I type in my custom formula it gives me this error: #NAME? Error Unknown function: 'myfunction'.

For simplicity sake, I have just been using the following simple function so I know the issue isn't with my functions code

function myFunction(input) {
  var output = input * 2;
  return output;
}

That exact code works for me. Only things I did was cut/paste/save and then =myFunction(2) = 4. — Tom Woodward
Did it work when you ran it as a Test Add-On? Because the function works fine when it is just in the script file for the sheet, but I can't figure out how to make it work when I test it as an Add-On. — c.dimock

franfran franfran · Accepted Answer · 2019-02-13T07:04:21

I also tried to write custom function and publish as Add-on, but get "Error Unknown function" in the Spreadsheet.

Wasted several days on it, and finally got it working.