Forum Discussion

drmrbrewer's avatar
drmrbrewer
Copper Contributor
Sep 28, 2023
Solved

Format calculated column as hyperlink to navigate like the Name column

I have a calculated column which is populated with content from my custom Subject column, and if that is blank then it falls back to what is in the standard Name column (or a tracked version of that,...
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Sep 29, 2023

    drmrbrewer Try using this JSON: 

     

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "attributes": {
    "class": "ms-Link"
  },
  "customRowAction": {
    "action": "defaultClick"
  }
}

     

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

ganeshsanap's avatar
ganeshsanap
MVP
Sep 29, 2023

drmrbrewer Apply below JSON column formatting for your calculated column: 

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "customRowAction": {
    "action": "defaultClick"
  }
}

 

You can customize the style (font/color, etc.) of the column as per your requirements if needed.

 

Documentation: Use column formatting to customize SharePoint 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources