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

I have created a custom list in Sharepoint 2010 with below columns.

Name(Single line of text)
Location(Single line of text)
Manager(Single line of text)
Joining(Radio button with Yes/No values)

In the default view created, I can see all the rows that have been entered. I want to display only those entries that have value "yes" in Joining column. Please help. Thanks in advance.

share|improve this question

migrated from May 17 '12 at 16:26

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

All you have to do is modify the default view (either by going to the list settings, scrolling down, and clicking on All Items; or by clicking on List under the List Tools header in the ribbon and selecting Modify view).

Within modify view there is a Filter section where you can choose the column Joining, leave it as 'is equal to' and write in Yes as the value there.

share|improve this answer
Thanks for your answer, I want to know one more thing. I have another column "comments" that is multiple line of text type. I want to select all the entries that have value in comments column but SharePoint does not allow me to use this field with "is equal to" or "is not equal to". – NotesArt May 17 '12 at 13:34
Unfortunately, to do so you would need to either use sharepoint designer and convert it to a data view or do something 'hackish' like doing a contains for a, e, i, o, u, or y, which should return any valid comment – Zork May 17 '12 at 20:08

Your Answer


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.