Jan 12 2021 01:28 PM
I have a choice column with about 30 items. I just added a couple of more items but now they are at the bottom of the list and I don't see how to sort them. In the old days, everything was in one text box and I could just easily add them in the correct location. That no longer works.
I can't just copy them all and sort in excel as needed either.
Jan 13 2021 04:35 AM
Solution
As you know, SharePoint will not automatically order the choice selections and you need to sort them in excel, then paste the sorted choices again to choice column settings.
To do this follow below steps:
Additional Reference: Sorting Choices in Choice Field
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Jan 19 2021 05:38 AM
Didn't think about doing it from the settings. I was trying to do it from the list itself but editing the column. You use to be able to do it that way.
Thank you!
May 11 2021 10:18 AM
This method of placing items in alphabetical worked fantastic; thanks for the suggestion!
May 11 2021 10:24 AM
You're welcome @dmdanleaf
Glad it helped you!
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Jun 14 2022 11:24 AM
@ganeshsanap Does this remove the formatting (colors) of the choices?
Jun 14 2022 10:18 PM
@BeckyH13 If you have already created a choice column with all the choices from modern experience & just changing the sort order of choices from column settings (not adding any new choice option), color formatting will not be removed.
If you are adding any new choice from (classic experience) column settings page, that will not be considered in column/color formatting JSON.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Jun 16 2022 01:05 PM
Jun 16 2022 10:16 PM
@BeckyH13 You're welcome! Glad it helped you.
Please consider giving a Like if my post helped you in any way.
Jan 13 2021 04:35 AM
Solution
As you know, SharePoint will not automatically order the choice selections and you need to sort them in excel, then paste the sorted choices again to choice column settings.
To do this follow below steps:
Additional Reference: Sorting Choices in Choice Field
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.