SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I currently have a list created with multiple column and column types. One column is a formula based on the answer of another....I need to change the column to a Yes or No choice instead of relying on the answer of the other column. However, whenever I go to edit that column, it will not let me change the!

share|improve this question

You are unable to change the types of Columns in SharePoint lists - simply because it's impossible to guarantee how to transform the data stored in one column type to another.

What you can do, is create your Yes/No column, go to DataSheet view, and see if you are able to copy/paste the values from your calculated column over to the new Yes/No column.

share|improve this answer
Actually you can change column types, some of them are convertable. But not all, as in this case. – Andrey Markeev Jul 28 '11 at 18:59

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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