Tag Info

Hot answers tagged


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 ...


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). ...

Only top voted, non community-wiki answers of a minimum length are eligible