Calculated Columns missing fields

On some lists or libraries you might not see all the fields on that list or library as Columns that can be inserted into Calculated fields.  Some field types like the ones highlighted below cannot be uses in Calculated Columns:

If I try to create a new calculated column on the All Field Types List, I only see the valid type fields listed where I can insert them into the Formula:

The field types that cannot be used in Calculated Columns are:

  • Choice (Checkbox)
  • Multiple Lines of text
  • Person fields (including the Created By and Modified By fields)
  • Hyperlink
  • Lookup
  • Managed Metadata


Work around for missing fields

You can use a workflow to take the value from one of the field types that aren’t allowed in Calculated Columns, and copy that value into a new single line of text field on the list/library.

You will then want to hide the field from the list/library since your workflow will be populating the value.

About Nick Hurst (85 Articles)
SharePoint and Nintex developer who strives to find easy to deploy and maintain solutions for business problems.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: