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 type....help!

1 Answer 1


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.

  • 2
    Actually you can change column types, some of them are convertable. But not all, as in this case. Jul 28, 2011 at 18:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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