Create a Hyperlink using SharePoint Calculated Column

Are you trying to create a hyperlink in SharePoint? Maybe using a SharePoint calculated column. Microsoft officially does not support and blocks the execution of HTML markup in SharePoint calculated fields.

Alternatively, you can use JSON Formatting to make the hyperlink clickable as a solution for this requirement.

In this tutorial, I will guide you through two examples on how to create a Hyperlink in a SharePoint calculated column:

1. Create a Hyperlink URL with a calculated column, then apply JSON format
2. Create a Hyperlink Directly by applying the JSON format

Example 1: Create a Hyperlink with SharePoint Calculated Column using JSON Format

In this example, I will show you how to create a website URL for a Hyperlink using a SharePoint calculated column. Then, how to apply the JSON formatting to make the website URL clickable.

I will consider a SharePoint list ‘Training Courses‘ that has Website Titles as shown in the screenshot below. I wanted to create a hyperlink for those websites.

First, let’s create a Website URL using the calculated column.

Follow the steps below:

1. Open the SharePoint list, click on the + Add column, and select See all column types. Then, click on the Next button, as shown below.

2. Then, on the Create Column page, enter the Column name (Website Full URL), and select the data type as Calculated (Calculation based on other columns).

3. Now, add the formula under the Formula box as shown below.

="https://www."&Title&".com"

Make sure to select the “Number” data type to return from this formula. Then, we will only get clickable hyperlinks. Click on the Ok button.

4. Now, add the title, such as the website name. We will then get a hyperlink without a clickable option, similar to the one below.

This way, you can create a Website URL for a clickable hyperlink using a calculated column in SharePoint.

Apply JSON Format to the Created Calculated Column:

Now, let’s see how to make the Website URL a clickable link. See the steps below:

5. Expand the calculated column, then tap Column settings and select the “Format this column” option.

6. Next, click on the Advanced mode link, remove the column custom format, and add JSON format; then click on the Save button.

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"txtContent": "@currentField",
"attributes": {
"target": "_blank",
"href": "@currentField"
}
}

7. Then, you can see a hyperlink in the ‘Website Full URL‘ column in the SharePoint list.

Check out SharePoint Calculated Column Date Examples

Example 2: Create a Hyperlink in SharePoint Calculated Column Using JSON Format

This example demonstrates how to create a hyperlink in a SharePoint list calculated column using the JSON format.

Check out the steps below:

1. Open the SharePoint list, click the + Add column, and select See all column types. Then, click on the Next button.
2. Then, enter the Column name on the Create Column page (User-Friendly URL). Select the “Data Type” (Calculated) and add the formula in the Formula box. Then select the Ok button.

="Website URL"

3. Once you add the calculated column, it will appear as shown below. This text is also not clickable until we apply json formatting.

Apply JSON Format to Calculated Column [User-Friendly URL]:

4. Expand column header of User-Friendly URL->Select Column settings & Format this column option. Then, click on the Advanced mode link. Paste the following JSON Format and save it.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "txtContent": "[$Title]",
  "attributes": {
    "target": "_blank",
    "href": "='https://www.' + [$Title] + '.com'"
  }
}

5. Then, we will obtain a clickable hyperlink in the SharePoint list calculated column [User-Friendly URL] like in the screenshot below.

In this tutorial, I have covered two methods for creating a hyperlink URL in a SharePoint calculated column by applying JSON formatting to the column.

Do let me know if you still have any questions in the comments below.

You may also like:

• SharePoint Calculated Column Round Up to Decimal Places
• LEN() Function in SharePoint Calculated Column
• SharePoint List Calculated Column Concatenate() Function
• How to Calculate Average Value in SharePoint List?

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.