List Filters and multiple values?

Question

_{Friday, January 10, 2014 3:31 PM}

Hello, I'm having an issue where I can't get SharePoint to filter the values the way I want.

Suppose I have the following columns and data,

Color1 |  Color2 |  Color

Blue | Green | Blue, Green

Red | Green | Red, Green

I'd like to be able to filer the "Color" column by Green and get "Blue, Green" and "Red, Green".  However, hen I import these values from Excel to the SharePoint access app, Sharepoint recognizes this as only a single string of text.  (i.e. I can only sort by "Blue, Green" to get "Blue, Green" - I can't search by "Blue" and get "Blue, Green".  I want either 1 of 2 things to happen:

Sharepoint recognized that the comma seperated values are 2 seperate values and inset it as such. (allowing me to filter properly..)

OR

Sharepoint allows me to set the default filtering to search for a CONTAINS instead of EQUALS.

Is there any possible way to do this? Thanks.

All replies (3)

_{Friday, January 10, 2014 4:08 PM ✅Answered | 2 votes}

SharePoint uses a unique separator for dileneation between two values being selected in a multiselect field... its other than ','.

when you look at the standard view, it shows blue, green, however the data behind it would look like this:

;#Blue;#Green;#

so if you need blue AND green, try making your field a Choice - checkbox (allow mutliple values) and paste it into datasheet view with a ;# separator instead of ,

_{Friday, January 10, 2014 4:22 PM}

Thank you, this works!!!!!

_{Thursday, May 12, 2016 9:37 AM}

Hi,

i have the same problem, but i can't use a choice-column.

Im using a single line of text with ';' separators (tried also the ';#' separators) but it did work.

(I have a library with documents and i want them to have a buzz-word column. Every Dokument has a few Buzz-words, and sometimes two dokuments have one in comon. So i need the possibility to filter the library)