Creating a link to the same sheet that you are on.
Is there a way to use the Hyperlink -> Link to Another Sheet function to link back to the sheet that you are already on. I know it sounds strange. Why would I want to have a hyperlink back to the sheet I am already on.
I have Control Center instance that creates a package of sheets for each project. One of theses sheets contains project data that my users need to edit. It also contains my master set of navigation links that all other sheets in the package reference to use in their navigation sections, so if I have to change a nav link, I can do it in one spot on this sheet and it then populates to the 20 or so other sheets in the project package. So I need a way to put a link back to itself, so that when other sheets refer to it, it gives those sheets a link.
I know a work around would be to create a report and link to that, however that will not work in my case. One of the things my project managers do is upload graphics to this sheet that are then displayed on a dashboard. You cannot upload a graphic to a report (at least to my knowledge) you have to upload it to a sheet. So they are forced to use this sheet. I guess I could create a different sheet for the graphics and then link back but that is getting very awkward.
Help Article Resources
Check out the Formula Handbook template!