Custom function not recognized

Question

I created anew function in sheets from within a sheet. The function is not recognized:

function DOUBLE(input) {
  return input * 2;
}

More info. I'm on the new version of sheets if that makes a difference. Also I have two scripts attached to the sheet. — Doug Fir
– Doug Fir, Commented Aug 18, 2015 at 18:52
I don't understand why there is a slash in. "unknown function 'double/'". Have you tried retyping your formula in a few other cells? Not copy and paste but retyping. — ScampMichael
– ScampMichael, Commented Aug 19, 2015 at 2:20
Hi @ScampMichael I opened the sheet again just now. For another reason I had cleared by browsers cookies about an hour ago. The custom functions are now working as expected. Don;t understand why they did not before I have not changed anything else, cookies must have been it. The backslash was a typo on my part — Doug Fir
– Doug Fir, Commented Aug 19, 2015 at 3:32
I had this issue and I realized it was because I was editing a sheet with my work identity, but every time I opened the script editor, it opened with my personal identity and so I was saving my script in the wrong place. Unfortunately, trying to switch identities in the script editor led to a "you must request permission...request not sent—would you like to request permission?" loop. Opening the sheet and the script editor in an incognito window solved this. — moraleboost
– moraleboost, Commented Apr 1, 2020 at 15:08

Doug Fir · Accepted Answer · 2015-08-19 03:34:21Z

6

Clearing my cookies seemed to do the trick. Not sure if that qualifies as an answer but if anyone else comes across this post I hope that helps.

answered Aug 19, 2015 at 3:34

Doug Fir

21.5k57 gold badges196 silver badges352 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Had the same problem and hard refresh + clearing cache fixed it. Thanks!