SharePoint calculated column with hyperlink

Question

I have a SharePoint list as "Training Courses" and inside this, I have added a calculated column named "Website URL".

Here, My requirement is if a user enters the website name in the title column, then we will get Website URL under the calculated column.

Please, suggest any formula for implementation...

Answer 1

SharePoint online calculated columns does not support HTML anymore to create a clickable hyperlink.

So, I will suggest you to use the JSON formatting to make it clickable.

Solution 1:

1. Create a Website URL calculated column with this formula: ="https://www." & [Title] & ".com"
2. Apply JSON column formatting for your calculated column using this JSON:

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

Output:

Solution 2:

1. Create a Website URL calculated column with simple formula like: ="Website URL"
2. Apply JSON column formatting for your calculated column using this JSON:

{
  "$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'"
  }
}

Where Title is the name of your internal column storing website name. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?

Output:

Apply JSON column formatting by following steps given here: Use column formatting to customize SharePoint