Custom functions not working in the spreadsheet

Question

I followed these instructions: https://developers.google.com/apps-script/execution_custom_functions to create a custom function.

Neither my functions, nor even cutting and pasting from the textbook work: these functions are not available for my spreadsheets. I tried to save the version and publish it as a web application - no change. I tried Google Chrome and Firefox, the same result. Did I miss something really obvious here?

Answer 1

Not sure if this is what you came across ... but what happened to me, I didn’t see my own autocomplete function, and I thought it didn’t work. But if you just type = double (A1) in a cell (using an official example, assuming there is something in A1 ...), it will calculate!

Answer 2

You should have a comment with @customfunction in it over your custom function. Then Google Sheets will add a custom feature to the autocomplete menu.