I have a calculated column that worked in SharePoint 2007, 2010, 2013, and 2016. But now in SharePoint 2019 the calculated column is not appearing right in the column instead of showing the employees email address as a hyperlink it now shows the DIV tag info

Is this SharePoint 2019? Why is this not working?

=CONCATENATE("<DIV><a href='","mailto:",[E-Mail],"'>",[Full Name (First M.I. Last)],"</a></DIV>")

Sadly I think that is the way it is headed. According to this article, the June 2017 update for SP 2013 and 2016 included a switch called CustomMarkupInCalculatedFieldDisabled. It allowed your administrator to choose if HTML would show up for calculated fields.

I can't find complete documentation, but searches seem to suggest that the switch is no longer available in 2019.

|improve this answer|||||

Apparently using JSON column formatting is the way to go


   "$schema": "https://developer.microsoft.com/json-schemas/sp/v1/column-formatting.schema.json",
   "elmType": "a",
   "txtContent": "@currentField",
   "attributes": {
   "target": "_blank",
   "href": "='http://finance.yahoo.com/quote/' + @currentField"

} }

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.