In this article we will show you how to add a dynamic hyperlink Google Sheets in just a few clicks. Simply follow the steps below.
The Static Part of your URL is the part that does not change when switching between sheets. This is normally the site domain or website host.
Make sure to include even the last symbol to make your dynamic hyperlink work.
We can observe that everything after GID= changes as the chosen worksheet changes thus the static part of the link in our example is
the blue highlighted part in the screen shot below.
The Google Grid ID or GID is the generated number after the static part of your Google Sheets URL.
Looking at Sheet 3, we can see that its GID is 1998460755.
Here is what our worksheet would look like with the Google Grid IDs for each sheet.
We will use the ampersand sign (&) to connect both parts.
Formula Breakdown:
Static Part: The website domain you’ve obtained in step 1. Enclose this in quotation marks.
Article Extension: The dynamic part of our URL. We will use cell references for this one.
Following this breakdown, we will use =”Static Part of URL(see first photo)”&B2
Tip: You can also use this technique in combination with the hyperlink formula too! A tutorial for using the different ways to create a hyperlink can be found here: LINK
You can see that our links will automatically change and now you can access the others sheets through your dynamic hyperlinks.
You can also use the same concept when dealing with other types of links. Here’s a quick tutorial to create dynamic hyperlink for websites.
For our example, let us create dynamic hyperlinks of the different tutorials on the Lido blog site. The static part of our hyperlink will be https://www.lido.app/tutorials/
Link extensions will be the part of your URL that changes. For the previous article, this will be find-duplicates-google-sheets
The extension could be usernames on social media, unique number sequences or website pages. Here is what our worksheet for different articles would look like.
Connect the Static Part and the Article Extension with an ampersand (&) sign.
For our example, this will yield =”https://www.lido.app/tutorials/”&B2
You can see that our links will automatically change and now you can access the other articles through your dynamic hyperlinks.
