Forum Discussion
Change a Choice Column to a Yes/No column
Hi, I've created a SharePoint list from an Excel spreadsheet to use as a data source, and it has imported my data in some instances as Choice columns. However, I want them to be Yes/No columns. Un...
Go with "Boolean" type to get the yes/no column.
Navigate to Your SharePoint List:
- Go to your SharePoint site and open the desired list.
Access List Settings:
- Click on the gear icon :gear: or "Site Actions" (depending on your SharePoint version) and select "Site contents."
- Find and open the specific list for which you want to create the column.
- Inside the list, click on the settings icon (typically :gear:) and select "List settings."
Add a New Column:
- Under the "Columns" section, click on "Create column."
Configure the Column:
- Provide a name for your column, for example, "Yes/No Field."
- For the type of information, select "Yes/No" (which represents boolean values).
Further Settings (Optional):
- You might have additional settings like default values or validation settings. Adjust them according to your needs.
- Click "OK" or "Save" to create the column.
What you are seeing is corret, you cannot convert a choice column into a Yes/No (Boolean) column
It's not correct at all. He wants to know how to change his column type. There is no correct or incorrect. The user needs to change his column type to what he needs, not what Microsoft tells him he can and cannot have. jcgonzalezmartin
- Ok,
Let me say it on a different way: He cannot change the column type from choice to boolean because it's not supported. Only solution here is the workaround provided by Neeraj.
