SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Have assigned default column "Assigned To" for new list "Issue Tracking" with following settings:

  1. Require that this column contains information: No
  2. Allow multiple selections: Yes
  3. Allow selection of: People and Groups
  4. Choose from: SharePoint Group

SharePoint prevents me from sorting this column in View "All Issues", with message, "This column type cannot be sorted."

Is it possible to sort columns containing multiple values, and if so, how?

Running SharePoint 2007 SP1 (KB936984, KB942390) December 11, 2007, 12.0.0.6219

share|improve this question
up vote 2 down vote accepted

After a quick google search it looks like you may need to change multiple selections to NO and or only search for People not groups.

See link below for more details: http://social.technet.microsoft.com/Forums/en-US/sharepointadminprevious/thread/b748bb03-4881-4aa5-9c87-bd4558b9201c

share|improve this answer

Similar to http://stackoverflow.com/a/38020258/708685, you should be able to. While your column Assigned To has allow multiple values enabled, fill in all of your data as needed. Once done, turn off allow multiple values. SharePoint will pop up a warning about how this data may be lost (so far has never happened to me). Hit okay, then modify the view you want sorted, "Assigned to" should now show up on the drop down of columns to sort by.

Should keep in mind though that if you are sorting by multiple terms and you put them in inconsistently, you could have, in my example, "Conway"; "Myrtle Beach" being with the rest of the "Conway"s and "Myrtle Beach"; "Conway" with the rest of the "Myrtle Beach"s when you probably wanted them to be together.

share|improve this answer

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.