Content Type column not available for Calculated field

Content Type column not available for Calculated field calculations in SharePoint 2010. In SharePoint 2007 if you have a Calculated field using content type in its formula, if you migrate to 2010 or even 2013, you will see any error in calculation.

[Content Type] in calculation is replaced by ‘#Name?‘.

Content Type column not available for Calculated field

Content Type column not available for Calculated field in SharePoint 2010

In SharePoint 2010 and later versions, Content Type is not made available for Calculated field calculations. If you use it in 2007, after migration, it will end up in broken state. Either you need to reconsider your design or use customization to get around the issue.Content Type column not available for Calculated field in SharePoint 2010

Field types of text, number, datetime, choice, workflowstatus, boolean and calculated are available for Calculated column formula’s. Since content Type is of type ‘Computed’ it is not made available.

So, don’t freak out after migration if you see a formula with ‘#Name?’ instead of [Content Type] in it.

 

 

 

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SharePoint Designer cannot display the item

You run into ‘SharePoint Designer cannot display the item’ error when you are trying to edit an existing workflow setup in Designer quite often when there is a windows update or update to .NET framework installed in your computer. In some cases it may also not allow you to create new workflows. Resolution: Clearing Designer […]

Read More

Windows security prompt. Connecting to SharePoint….

Users often run into this issue. Windows security prompt pops up every 15 minutes or so repeatedly trying to connect to SharePoint. No matter you enter credentials or cancel, user will be prompted for credentials again and again. SharePoint may not be the culprit all the time. List of things I check whenever I run […]

Read More

User with Contribute access gets access denied

Only one user with contribute access gets access denied to SharePoint site collection. Every SharePoint admin might have faced this issue atleast once. In my case, user is added to a SharePoint group with Contribute access. Access shows up as Contribute when verified through site permissions – check permission option. Every other person in the […]

Read More