SharePoint Calculated Column not Displayed in View

Question

_{Thursday, July 1, 2010 2:52 AM}

I created a calculated site column that multiplies two other columns together.  Then all 3 columns are added to a custom content type.  I then create a list based on that content type.  This is all done in SharePoint Designer 2010.  When I go the the SharePoint site and try to modify the view, the calculated column is not available but the other two fields are.  Are calculated column not fully supported?

Also, once I have added the calculated column to the content type, the column is greyed in SharePoint Designer and I am not able to remove the column from the content type.  I cannot delete the content type either.  It says it's in use even after I have deleted the list that was using it. Is there some hidden trick to using calulated columns or do they just not work.

All replies (3)

_{Thursday, July 1, 2010 4:52 AM ✅Answered | 1 vote}

Hello,

You can read this post - http://community.bamboosolutions.com/blogs/bambooteamblog/archive/2009/04/24/how-to-total-calculated-columns-in-a-sharepoint-list.aspx

or this - http://blogs.sharepointace.com/post/SharePoint-List-Calculated-Column-Calculate-Business-Days.aspx

Sergey A Belskiy - Team Leader of developers, DEV-pro || My blog || My twitter || My space || My video

_{Thursday, July 1, 2010 3:01 AM}

Just to update this.  Calculated columns seem to work better if added directly to a list and not included in a content type.

_{Friday, August 16, 2013 4:59 PM}

I know it has been a while since you posted this, but I just faced this same problem and found a simple solution (at least for my problem).

Rather than creating a calculated column, create a Date/Time column and use the Calculated Value option in the column settings.  This worked for me...in my case I wanted it to display a date 16 days out from the day the item was created.  The formula:  =Today+16

It made the future date show up in the list, plus it allowed the user to modify the date if the want to.

By the way - this is in SharePoint Server 2010 - Standard version. :)

Shirley