Some Sheets unable to load custom functions since yesterday

Travis Yip

unread,

Mar 3, 2022, 8:52:13 AM3/3/22

to Google Apps Script Community

Since around 24 hours ago I had the issue that the custom functions in Google Sheets are not able to be executed - it just does not run the function at all. If I look at the app script executions, it does not even show up the function. It happens very randomly. It stopped running for 12 hours since 13:30 yesterday (GMT+8). It worked this morning up until now. And now 30% of my sheets could not run custom functions.

It could not run a function as simple as this: function double(input) { return input * 2; }. It keeps showing "loading".

If I enter the GAS console and run manually it's totally fine.

I wonder what's going on and it's extremely annoying.

Jeremy Short

unread,

Mar 3, 2022, 11:53:01 AM3/3/22

to Google Apps Script Community

I'm having the same issue but other people at my organization aren't having the issue in the same sheet so it might just be a weird one off thing.

Elmo Mouchas

unread,

Mar 3, 2022, 11:53:27 AM3/3/22

to Google Apps Script Community

I have the same behaviour/problem here since yesterday afternoon, where I also had a small window of an hour or two where it worked and it stopped working again.

Is it possible it is a matter of quotas ?

I look everywhere to find out what is wrong, but I don't see any help or any errors in the dashboard

I am 2 fingers away to start injecting money in my account just to see if it change something.

On Thursday, March 3, 2022 at 8:52:13 AM UTC-5 Travis Yip wrote:

Travis Yip

unread,

Mar 5, 2022, 8:31:58 AM3/5/22

to Google Apps Script Community

i dont think it's one-off as today is the third day i'm experiencing this problem in multiple sheets. The annoying thing is the service status of google sheets says it's totally normally and I couldn't find any ways to report.

Dan Popa

unread,

Mar 5, 2022, 8:32:12 AM3/5/22

to Google Apps Script Community

Same issue, custom functions don't work, the sheets API is veeeery slow.

Darren D'Mello

unread,

Mar 6, 2022, 1:56:25 AM3/6/22

to Google Apps Script Community

Please create a issue tracker and share us the url. We can star it. The more starts it receives likely to get a quick fix.

There is no way to report unless this group has any engineer who is working in the very same concerned department.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/bf49c2e9-e8fe-4277-93f1-fc36e242c5cdn%40googlegroups.com.

Andrew Apell

unread,

Mar 7, 2022, 4:33:09 AM3/7/22

to Google Apps Script Community

My users have also reported this to me today.

Has anyone reported the bug so that we can lend our voice of support to it?

Martin Hawksey

unread,

Mar 7, 2022, 5:29:24 AM3/7/22

to Google Apps Script Community

Hi Andrew - and others impacted by this

There is a ticket on the slowness of custom functions here https://issuetracker.google.com/issues/222342097

Google have acknowledged there is an issue which is being investigated. There appear to be some other tickets for general slowness particularly of .getValues()/.setValues() https://issuetracker.google.com/issues?q=componentid:191640%20%20status:open%20slow

Andrew Apell

unread,

Mar 7, 2022, 7:27:36 AM3/7/22

to Google Apps Script Community

Thanks for the info Martin.

Reply all

Reply to author

Forward