Share via

Calculated Column with HTML not rendering anymore

Anonymous
2017-06-14T13:19:52+00:00

Good Morning,

In our SharePoint 365 site we have a calculated column with HTML in it to display whether tasks are overdue or not. This worked fine until yesterday morning when one of our users logged in and only the HTML code was displayed instead of the icon. Here is the formula and html that worked until yesterday:

=IF([Days Remaining]<0,"<html><DIV><img src='/_layouts/images/KPIDefault-2.GIF' title='Past Due Date' height='8' width='8'></DIV></html>",IF([Days Remaining]<6,"<html><DIV><img src='/_layouts/images/KPIDefault-1.GIF' title='Within 5 days of Due Date' height='8' width='8'></DIV></html>","<html><DIV><img src='/_layouts/images/KPIDefault-0.GIF' title='Greater than 5 days until Due Date' height='8' width='8'></DIV></html>"))

I checked the img src and they are all valid links. This is also happening at other SharePoint 365 sites I've built as well.

Any assistance is greatly appreciated.

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2017-06-14T19:42:30+00:00

Hi Edward,

In Microsoft SharePoint lists and libraries, calculated fields that are running in the classic UI mode can be used to display results based on Excel-like formulas. This is a long standing capability, and is documented in Calculate data in lists or libraries.

Some users have added HTML markup or script elements to calculated fields. This is an undocumented use of the feature, and we will begin blocking execution of custom markup in calculated fields in SharePoint Online from June 13, 2017 onwards.

We are changing calculated fields to escape special characters. In some circumstances, this means that calculated fields that contain any unsupported markup will not display any value. Instead, they'll be blank in the list view.

This change will take effect on June 13, 2017. Administrators can request an extension through September 10, 2017 at the latest. During this time, special characters will not be escaped in calculated fields. This request can be submitted through Microsoft Support. However, beginning September 10, 2017, all unsupported markup will be ignored.

For more information, please refer to the following KB.

Handling HTML markup in SharePoint calculated fields

Thanks,

Ran

Was this answer helpful?

7 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-06-14T16:02:37+00:00

    Hi Edward,

    I would like to collect your tenant information to involve our related team checking this. To protect your privacy, I have sent you a private message (PM) to collect them. You can check the PM via the link below:

    https://answers.microsoft.com/en-us/privatemessages/list

    Meanwhile, please click list settings > click on the column name > capture a whole screenshot of the edit column page to us.

    Regards,

    Linda

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-06-14T16:01:14+00:00

    Hi Edward,

    I would like to collect your tenant information to involve our related team checking this. To protect your privacy, I have sent you a private message (PM) to collect them. You can check the PM via the link below:

    https://answers.microsoft.com/en-us/privatemessages/list 

    Meanwhile, please click list settings > click on the column name > capture a whole screenshot of the edit column page to us.

    Regards,

    Linda

    Was this answer helpful?

    0 comments