Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

SP List Calculated field disp whole formula,instead of value

Home
Forums
SharePoint

SP List Calculated field disp whole formula,instead of value

Murali Kris

6yAsked Nov 8, 2019, 10:23 PM1.3kSharePoint

Actyally list have two calculated fields

1.Colour( formula is working fine)

2.Display (instead of value it is displaying whole below caculated formula)

=" "&Title&""

insted of color with value, Display column displaying whole above formula.

How to fix this what is the issue in the span tag..?

Kindly help me

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Abhijeet Jadhav6y ago
Accepted answer
Hi Murali,

Microsoft has disabled the rendering of HTML markup from June 2017, PFB link :
https://support.office.com/en-us/article/handling-html-markup-in-sharepoint-calculated-fields-a3db28e4-747c-437e-b085-8f795b722a8c?ui=en-US&rs=en-US&ad=US

If you are using SharePoint 2013 on prem you can disable this setting by toggling the flag :
#Execute below code in  SharePoint Management Shell


$Web = Get-SPWebApplication http://weburl
$Val=$Web.CustomMarkupInCalculatedFieldDisabled=$False
$web.update()

# verify if the flag is disabled.

$Web.CustomMarkupInCalculatedFieldDisabled
0
Murali Kris6y ago
Hi Abhijeet,

It`s for sharePoint online, since site is in modern experience i used column farmatting using JSON. issue is fixed.
Thank you for you reply. it might be helpful for onPrem.
0