I've followed the instructions from: https://developers.google.com/apps-script/execution_custom_functions to create a custom function.
Neither my functions or even cut and paste from the tutorial works: the functions aren't available to my spreadsheets. I've tried saving a version and publishing as a web app - with no change. I tried Google Chrome and Firefox, same result. Am I missing something really obvious here?
Does your Chrome Popup setting determine whether the customFunction autocompletes when you enter in in a cell? If so how would you add it as an allowed exception in settings? Enable autocomplete is checked under the tools menu in the spreadsheet.
My function works fine if run from the script editor but does not autocomplete when =myCustomFunction or =myCustomFunction( entered in a cell.
You will need to add JS-Docs before your function to make it work. https://developers.google.com/apps-script/guides/sheets/functions#autocomplete
/**
* Divides the input value by 2.
*
* @param {number} input The value to divide.
* @return The input divided by 2.
* @customfunction
*/
function HALF(input) {
return input / 2;
}