Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 1 down vote favorite

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!

share|improve this question

1 Answer

up vote 4 down vote

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
2  
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

 
discard

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.