Unknown function: 'Supermetrics' - Issue

630 views
Skip to first unread message

han...@lostmy.name

unread,
Jun 28, 2016, 9:45:40 AM6/28/16
to Supermetrics
Hi there,

My spreadsheets is no longer loading, and the formulae reporting the error "Unknown function: 'Supermetrics'. The script editor still includes the Supermetrics functions which are given in the Supermetrics google sheet template. I've attached a screen shot of the spreadsheet. Any help on how to fix this problem would be greatly appreciated.

Many thanks,
Hannah


Screen Shot 2016-06-28 at 11.31.22.png

Mikael Thuneberg

unread,
Jun 28, 2016, 9:51:42 AM6/28/16
to automate...@googlegroups.com
Try opening the Supermetrics add-on in that file.

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at https://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/c395d126-1a4b-4f22-8cd5-faca7266bfab%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

han...@lostmy.name

unread,
Jun 28, 2016, 10:04:10 AM6/28/16
to Supermetrics
This doesn't help - When I refresh the queries using the add-on, nothing changes. It still comes up with a #NAME? error, saying "Unknown function"

Is there anything particular I'm supposed to do when I launch the supermetrics add on? 
Screen Shot 2016-06-28 at 14.59.43.png

Mikael Thuneberg

unread,
Jun 28, 2016, 10:06:27 AM6/28/16
to automate...@googlegroups.com
Is the function name exactly the same on the spreadsheet and the Script editor? It's case-sensitive.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/2ffb4f68-e070-44a3-b98c-cf9813b8e6ff%40googlegroups.com.

han...@lostmy.name

unread,
Jun 28, 2016, 10:26:47 AM6/28/16
to Supermetrics
The function names are exactly the same, and are the same cases as in the template. 

Weirdly the spreadsheet worked last week, and now doesn't. We haven't made any changes to it.

han...@lostmy.name

unread,
Jun 29, 2016, 5:24:07 AM6/29/16
to Supermetrics
Hi supermetrics, any chance of some more help?

Mikael Thuneberg

unread,
Jun 29, 2016, 5:27:24 AM6/29/16
to automate...@googlegroups.com
No idea what could cause this, sounds like an issue with Google Sheets and not our product.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/cdadbcea-8085-4f4b-898f-194c1209509b%40googlegroups.com.

Cyril Nautin

unread,
Jul 5, 2016, 9:42:03 AM7/5/16
to Supermetrics
Having the same issue, does anyone found a solution ?

Clinton Deacon

unread,
Jul 6, 2016, 4:59:44 AM7/6/16
to Supermetrics
Could you share the sheet with in...@supermetrics.com to help us investigate the issue?

Kind Regards

Clinton Deacon
Senior Application Developer

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/e799de71-e05b-447e-9c05-e40c769e5681%40googlegroups.com.

Mikael Thuneberg

unread,
Jul 6, 2016, 5:20:31 AM7/6/16
to automate...@googlegroups.com
Go to Tools: Script editor, select any function from the dropdown, click play, approve permissions, reload spreadsheet.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/e799de71-e05b-447e-9c05-e40c769e5681%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages