Make a Dynamic Hyperlink in Google Sheets [Easiest Way 2024]

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.

Create a Dynamic Hyperlink to Another Sheet in Google Sheets

1. Copy the Static Part of your Google Sheets Link

‍

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.

‍

‍

2. Determine the Google Grid IDs/Sheet IDs for your worksheets

‍

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.

‍

3. In an empty cell, use the formula =”Static Part”&GID

‍

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

‍

4. Drag the formula down to the other cells

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.

‍

Create a Google Sheets Dynamic Hyperlink For Websites

1. Determine the Static Part of your Hyperlink

‍

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/

‍

2. List your Link Extensions in a new column

‍

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.

‍

3. In an empty cell, use the formula =”Static Part”&Article Extension

‍

Connect the Static Part and the Article Extension with an ampersand (&) sign.

‍

For our example, this will yield =”https://www.lido.app/tutorials/”&B2

‍

4. Drag the formula down to the other cells

You can see that our links will automatically change and now you can access the other articles through your dynamic hyperlinks.