How to generate an uuid in google sheet (for exemple ccb8a660-91c9-a556-58e0-4fa7-229516872004). Either with a macro? or a formula?

Problem: When I run the script, Google tells me, You do not have permission to call openById I had copied a script from another one of my Google spreadsheets and changed the target_ssKey vari...

SPECIFIC FOR: "NEW" google sheets only. This is a known issue as highlighted by google in the new sheets. Issues: If you write complex* custom functions in google-apps-script for google sheets, y...

I have a Sheets spreadsheet that has many cells that use a custom function which calls IMPORTHTML and parses the results. Other calculations in the sheet use the returned values from these custom f...

I am trying to create my first custom function for a Google Spreadsheet in Apps Script and I am having a hard time using the debugger. I am working on the custom function demo code from the Google...

While applying conditional formatting in Google spreadsheet, I was wondering if it's possible to use a custom function that I created via script editor in the field 'custom formula is:'. Here is wh...

I've been trying to create a Google Spreadsheet plugin from some existing Google App Scripts that I have, and one important part of this app script is Custom Functions. Though the documentation fo...