2

I'm not sure why I'm having this issue, as all material says that I should be able to do this...

I have a required choice field that I would like to use in a calculated column. However, when I try to do so, I get the error:

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

I'm not doing anything fancy, and have stripped down my formula in my calculated column to simply:

=[Event Type]

but still get the error. Am I missing something completely?

Edit: It looks like this is related to the list being migrated using DocAve Migration tools. Looking more into it through that venue.

1

I too faced the same problem. The actual issue is with the space inbetween Event and Type. So, I created a column 'EventType' and added the choice values. Created the calculated column which has reference to EventType. Now it will save without any issues.

After that edit the column and rename it to 'Event Type'. However you need not change the calculated field formula now as the SharePoint itself take care. If you go and view you can see the auto changed formula.

As you said this is a migration I am afraid you may get a data loss while you delete already existing field 'Event Type'

0

What kind of choice column you have, if its multiple values then its not allowed. complete detail

But if its only one option then you can use it: =IF([Column A]=”Important”,[Column B]+[Column C],”Not Applicable”)

  • I'm using a drop-down menu, so only once choice is allowed. – MetalAdam Jan 3 '14 at 16:12
  • Is there any reason why just displaying the value wouldn't work (instead of using the IF statement)? – MetalAdam Jan 3 '14 at 16:13
  • i just create a choice column with dropdown option( 3 choices), then in the Calculated column i just select the column from the list and its worked as expected. "columnname" – Waqas Sarwar MVP Jan 3 '14 at 16:19
  • Hm. It's looking like this is a problem related the list being migrated from an older version of SharePoint. I can create a new choice column and add that without any issues - but the column that come over in the migration continues to give me issues. – MetalAdam Jan 3 '14 at 16:39
  • what type of column in the old version? – Waqas Sarwar MVP Jan 3 '14 at 19:26
0

for me it works in choice column like :

=IF([column name]="choice value",TRUE,FALSE)

or try from list validation settings.

0

This worked like a charm!

I had a choice field called "Current_supervisor".

I created another Calculated field "Current_Supervisor_Calc" having formula -

 =IF(ISERROR([Current_supervisor]),"-",[Current_supervisor])

then used this for actual/main Calculated field

 =IF(Current_Supervisor_Calc="-",[Supervisor_TEXT],[Current_supervisor])

Happy SharePointing!

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.