In this post, we will discuss how we can work with Content-Type column field in a calculated column in SharePoint 2013. Just to let you know that this issue we face in one site which we have migrated from Moss 2007 to SharePoint 2013. Therein one the list they we using a calculated column which was using the content type column in the formula. The values were appearing correctly in moss 2007 site but in SharePoint 2013 the list column value was appearing like:
Also, you can read:
– Delegate Controls in SharePoint 2013 using Visual Studio 2013
Now when we check the formula in moss 2007 it appears like below:
=LEFT([Content Type],FIND(“Request”,[Content Type])-1)&”Project”
And the corresponding formula in SharePoint 2013 comes as:
Actually, the Content-Type column for the calculated column has been removed from SharePoint 2010 onwards. Column types of text, number, DateTime, choice, workflow status, boolean and calculated are available for Calculated column formula’s. Since content Type is of type “Computed” it is not made available.
So to make this work, we need to modify the logic and maybe need to redesign the list according to your requirement. In our case, we create another field and we put our logic there.
Hope this will be helpful.
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.
You May Also like the Following SharePoint Online Tutorials: