Advertisements

Sharepoint 2010/ 2013 – One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas

I can confirm that a Data Type Column cannot be used in a Formula. But there is an easy workaround using Workflows in SharePoint Designer 2010/2013 without any coding required

  • Create an additional Column in your list (DataTypeColumn01) as type Single Line Text
  • In SharePoint Designer, open the List from the specific website and click New on the Worflows tab

SharePoint_Workflow_01

  • Give the Workflow an appropriate name and select the Platform; either SharePoint 2010 /2013 Workflow
  • From Workflow Tab select Action – List Actions – Set Field in Current Item
  • Set DataTypeColumn01 to CurrentItem:DataTypeColumn
  • Use the lookup button next to the Action to achieve this

SharePoint_Workflow_Lookup.PNG

  • Save the Workflow
  • Enable the Start Options for the Workflow as per your requirement

SharePoint_Workflow_StartOptions

  • Publish the Workflow
  • You can now use the DataTypeColumn01 Column with any SharePoint Formula
Advertisements

Posted on May 15, 2016, in Sharepoint, Sharepoint 2010, Uncategorized. Bookmark the permalink. Leave a comment.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: