Google Sheets custom add-on installed but function shows 'Unknown function'

[Abhishek Sen]

Hi there,

I've just created an internal custom add-on via Google App Script and want to make it available for anyone in our organization using Google Sheets. 

The add-on shows up in the Add-Ons manager but after installing it, I don't see the function available for us when I click on a cell. 

I've tried removing the admin install and installed it just for myself - no luck. Any suggestions?

Best

Abhishek

[Alex]

Hi Abhishek!

As for me I have to wait for a day before the app publishing for all. Often this only applies to formulas.

[Ram Kiami]

Hi Alex,

Let me first thank you for being kind to offer scripts to automate sheets' creation for values listed in a pivot table. I am really struggling to find scripts online to solve this problem. Its complicated for me since I am not a programmer. I looked online and could not find any ready-made scripts.

I shared with you the link to the Sheet I am trying to create sheets to list the details of each value in the pivot table, instead of double-clicking each value to create a separate sheet. I hope I was able to explain the problem and the needed solution.

Here is the link just in case the invitation went to your spam folder: https://docs.google.com/spreadsheets/d/1NCfA_Rb2Xh_C3WMm3hzVQU72Jwuw6cSzwAPk9jU3C4Q/edit?usp=sharing

I already double-clicked one value and created a sheet for it just for the example. It would be cool to have a script that automates the process and it would be nice if it is possible to get rid of "Detail1-" in the naming of each sheet. 

I am happy to share any further details and available to chat over Google Meet if that is your preference.

Xrillion thanks in advance for your help. Much appreciated. 

Happy holidays!

Rami

--
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/12bb54bd-b2db-4f8a-9009-103c233998e2n%40googlegroups.com.