2

I have written Apps Script code for Google Spreadsheet to serve my personal purpose. I learnt from Google site that custom made things to show up in Google Spreadsheets mobile app it has to be published as add-on. Do we have to go only in this route to get my custom made functionality in google spreadsheet mobile app?

EDIT: I have to clarify my question, actually I have created custom menus to call custom functions in google spreadsheet. These custom menus are not shown in the google spreadsheet mobile app. This is my requirement.

Apology for not asking question clearly.

TheMaster
  • 45,448
  • 6
  • 62
  • 85
Ashok
  • 461
  • 2
  • 5
  • 23
  • You may refer with this [link](https://stackoverflow.com/questions/17104486/google-spreadsheet-custom-menus-are-not-displayed-for-anonymous-users) which stated that in order for Scripts to run on a Google Sheet, the user must be logged in and have "can edit" rights. This means that anonymous users will not be able to run a Script. You may also check this [forum](https://productforums.google.com/forum/#!msg/docs/dkmoAReitvY/UtP-EFRpEgAJ) for more information. – abielita Aug 22 '17 at 15:47
  • 1
    @abielita thanks for your reply. Link you have shared doesn't talk about google spreadsheet mobile app – Ashok Aug 23 '17 at 18:11

1 Answers1

0

No. Your understanding is wrong. As long as your custom function has been put in the script editor of that spreadsheet, it will work in Google sheets mobile app as a custom function. But it won't show the function name or syntax in the list of functions. But it works.

TheMaster
  • 45,448
  • 6
  • 62
  • 85