0

I have a 'single line of text column' and a calculated column. When I am adding reference of the 'single line of text' column to calculated column it gives me error of

One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas. for test column

There are other 'single line of text' columns that I am able to use in my calculated column. This error is for only one column. Has the column got corrupted in any way? Also the internal name and display name of the column is different. Can that be source of problem?

Update 1: The formula that I am using is pretty simple =[Approval Status]. That's it. The column [Approval Status] is a 'single line of text' type column, though its internal name is different. Using this formula itself it shows error.

  • It would help if you show us the exact formula – Danny '365CSI' Engelman Feb 20 '17 at 8:21
  • @Danny'365CSI'Engelman: Added code snippet. – Naveen Feb 20 '17 at 9:06
2
=[Approval Status]

Isn't that one of SharePoints workflow fields?

I presume you can't use it because the Workflow can set it at different stages and the Formula updating will either run before or after that update.

  • No, the field a custom field that I created. – Naveen Feb 20 '17 at 10:18
  • If it got a different internal name then a field with that name (SPs workflow feld?) already exists. – Danny '365CSI' Engelman Feb 20 '17 at 10:21
  • 1
    I think that was the problem. The column Approval Status is already there (as you said for workflow fields), and when I put it in formula it tries to resolve to that column which, it seems, is not of appropriate data type. Rather than the column that I created. What I did was to update the column name back to its internal name, update the formula and then update the column name back. Then it worked! – Naveen Feb 21 '17 at 5:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.