Tag Info

New answers tagged

1

You need a custom function contained in a script. For example, the output below is from entering B1 = hashtag(A1), etc, where hashtag is the custom function at the end of this post, placed in a script (go to Tools > Script Editor to paste it in). +---+-------------------------+-------------------------+ | | A | B ...


0

Google Apps Script (GAS) Google spreadsheets could be used in a similar way that Macros are used in Excel. In the first reference below you could find how to start with GAS. The second reference was shared in a comment to the question that includes a script and example that could be used to start with. References Extend Google Docs, Sheets, and Forms ...


1

Indeed, the first invocation of importrange cannot be nested within another function: the request for authorization does not "bubble up" (at first I thought this was an error on Google's part, but then considered that a single command can combine several importrange within it, so providing an authorization dialog in such a case would be extra complicated). ...


1

At this time there isn't a built-in function that gives the number of sheets, so you have to think around the alternatives to Extend Google Docs, Sheets, and Forms with Apps Script. It's worth to say that sheets doesn't have an inherent number, so you should determine how do you will assign a number to each sheet. One way is to assign a numerical prefix as ...



Top 50 recent answers are included