0

I have this column that I have created and and I wanted to change its type from multiple choice to an Yes/No option.

Unfortunately I don't see the option anymore.

cl

1 Answer 1

1

No.

It is not possible to change the field type of existing choice column to Yes/No(check box) in SharePoint.

You can change choice column to only below column types:

  1. Single line of text
  2. Multiple lines of text
  3. Choice (menu to choose from)
  4. Number (1, 1.0, 100)
  5. Currency ($, ¥, €)
  6. Date and Time

EDIT:

You can change Yes/No column to below column types:

  1. Single line of text
  2. Multiple lines of text
  3. Choice (menu to choose from)
  4. Number (1, 1.0, 100)
  5. Currency ($, ¥, €)
  6. Yes/No (check box)

For Indexed Error:

If you want remove the indexing on Yes/No column, then follow below steps:

  1. Go to List settings.
  2. Scroll down to "Columns" section. After all columns, you can see an option Indexed columns. Select it.
  3. You can see the list of all indexed columns here. Locate your Yes/No field in this list and click on it.
  4. To delete this indexing, click on Delete.
  5. Then again try to change the type Yes/No column.

Note:

  1. Before deleting indexed column, make sure deleting it will not affect your list view when list crosses list view threshold.
15
  • This site column used to be yes/no and then I tired to change it to choice option. Unofrtunately I get this error ''The type of this column cannot be changed because it is currently being indexed.'' i dont know what to do .
    – Ed1995
    Commented May 15, 2019 at 8:13
  • see updated answer. How many items are there in your list? Commented May 15, 2019 at 9:48
  • My Document library has around 11000 items on it ans a list can show me around 5000 items. All of those files used that column type so I dont really want to delete it
    – Ed1995
    Commented May 15, 2019 at 9:56
  • I am afraid, but you cannot change the field type from Yes/No to choice column if it is indexed. Commented May 15, 2019 at 10:02
  • What would have to all my items that used that coulumn type and I delete it ?
    – Ed1995
    Commented May 15, 2019 at 10:06

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.