Forum Discussion
SharePoint Online - calculated column no longer showing as hyperlink
A couple of months back I created a calculated column that was showing a hyperlink and I have just noticed that the calculation no longer works. The formula I used is below, note: I have removed ...
Here is the official fix, at least for on-premise:
# NOTE: =$False NOT ="$False" # In SharePoint 2016 Management Shell, run... $Web = Get-SPWebApplication http://weburl $Val=$Web.CustomMarkupInCalculatedFieldDisabled=$False $web.update() # To confirm it is now false... $Web.CustomMarkupInCalculatedFieldDisabled
I love OnPremise! There are so many configurations where I need Powershell, and here *tada* another good example. Thank you very much. This Option Needs to be set to false (CustomMarkupInCalculatedFieldDisabled) now the Hyperlink calculated columns work perfectly again (with datatype number).
I used the following script:
cls
Add-PSSnapin Microsoft.SharePoint.Powershell
$Web = Get-SPWebApplication https://intranet... #Your Intranet URL
$Web.CustomMarkupInCalculatedFieldDisabled=$False
$web.update()