Timeline for Link to specific sheet in Google spreadsheet
Current License: CC BY-SA 3.0
21 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 31, 2019 at 15:59 | review | Suggested edits | |||
| Jan 31, 2019 at 22:08 | |||||
| Mar 7, 2018 at 13:15 | comment | added | Scott B | Can this be used to simply redirect to a specific URL when a sheet tab is clicked? Since we cannot embed a Google map into a sheet (like an iframe), I need to redirect to my map when the "Map" sheet is clicked. | |
| Sep 20, 2017 at 0:08 | review | Suggested edits | |||
| Sep 20, 2017 at 7:25 | |||||
| Apr 30, 2017 at 11:59 | comment | added | Mandar Pandit | Better Option Available here: stackoverflow.com/a/18518779/1814867 | |
| Apr 13, 2017 at 12:57 | history | edited | CommunityBot |
replaced http://webapps.stackexchange.com/ with https://webapps.stackexchange.com/
|
|
| Sep 8, 2013 at 1:50 | history | edited | William Jackson | CC BY-SA 3.0 |
added 160 characters in body
|
| Jul 20, 2013 at 6:12 | comment | added | user44077 | Regarding the script to add the menu item, just hit Alt+shift+K. Gives you a pop-up menu with all the sheet names. Done. (This may be a new feature since you created that script) | |
| Dec 10, 2012 at 14:20 | comment | added | JBWhitmore | Wow, nice job with the tasks... | |
| Dec 10, 2012 at 14:19 | vote | accept | JBWhitmore | ||
| Nov 28, 2012 at 20:56 | history | edited | William Jackson | CC BY-SA 3.0 |
deleted 51 characters in body
|
| Nov 28, 2012 at 18:54 | comment | added | William Jackson | @JBWhitmore Consider my lengthy addition to this answer. | |
| Nov 28, 2012 at 18:54 | history | edited | William Jackson | CC BY-SA 3.0 |
Added Google Apps Script solution
|
| Nov 28, 2012 at 16:21 | comment | added | Lloyd | Is there a way to not make it open a new tab? | |
| Aug 28, 2012 at 4:16 | comment | added | JBWhitmore | Let me respond why I've upvoted, but not selected this as an answer (although, as per Alkix's answer it appears that gid is now stable?). I actually had this as my solution for a short while -- but every time I click it (it not only takes two clicks) it opens in a new tab... and soon I'm in a sea of new tabs for the same spreadsheet. sigh | |
| Aug 27, 2012 at 22:23 | comment | added | Alkix | I just did a test by creating two additional sheets in one of my docs. I noted the url of the second sheet (gid=1). Then I created a third sheet and noted that (gid=2). I then switched their places, and the gid remained the same, even after reloading the document. | |
| Jul 25, 2012 at 18:15 | comment | added | William Jackson |
There is a programmatic way to get the Id of a sheet, but, bizarrely, this is not the same as the gid in the URL. There is also a programmatic way to activate a sheet, but I'm having a hard time coming up with a suitable trigger for the function.
|
|
| Jul 7, 2012 at 16:36 | comment | added | Joe Casadonte | If you figure out a way to link by name, please post it! | |
| May 24, 2012 at 3:23 | comment | added | Simon East |
What I mean is, you cannot find out programatically what gid Sheet5 is, only manually. If it's position changes, it's gid changes, and you can no longer link to it reliably.
|
|
| May 23, 2012 at 15:23 | comment | added | William Jackson |
I'm not sure exactly what you mean. The sheets are numbered in order from the left starting at 0. So if a sheet named "Sheet5" is at gid=7, it should be the eighth sheet from the left.
|
|
| May 23, 2012 at 3:50 | comment | added | Simon East |
Yeah I think this is the only viable solution at the moment. Unfortunately I have not found a way to translate between the name "Sheet5" and the gid=7.
|
|
| Mar 22, 2012 at 18:31 | history | answered | William Jackson | CC BY-SA 3.0 |