Hiding calculated columns in a SharePoint Library / List

Requirement

Calculated columns by default appear on all out of the box display forms due to the fact that they are ‘optional’ when applied to the list / content type. There is no way to change it to hidden using the Web GUI.

Solution:

You will need to use SharePoint Designer to be able to set the column to Hidden.

  1. Open the site in SharePoint Designer, ensure you have the appropriate level of permissions.
  2. Click on Lists and Libraries
  3. Select the List / Library you wish to modify.
  4. Under Content Types, select the Content Type that has the calculated column.
  5. Under Content Type, click Edit Content Type Columns.
  6. On the columns editor, click on the calculated column you wish to edit.
  7. On the Property column, click ONCE on the word ‘Optional’ and wait. It will take 1-2 seconds before you see a dropdown box.
  8. Select the Hidden option, click  Push Changes to Sites and Lists and Save.

Your column should now be hidden.

 

 

Tags:

2 Responses to “Hiding calculated columns in a SharePoint Library / List”

  1. Kevin September 10, 2014 at 6:00 am #

    Thank you!

  2. Morteza January 3, 2016 at 7:33 pm #

    Thank you 🙂

Leave a Reply

%d bloggers like this: