SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

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 am creating a site for training documents. I have 2 fields, topic and category. Is it possible to filter the options within category depending on which option the user selects in the topic column using an IF expression? Any other suggestions of how to do this are welcome, I'm just not particularly hot at coding... Thanks in advance.

share|improve this question
up vote 0 down vote accepted

Check this out:

I'm not sure if this is the end all be all answer to this but there is a way you can write IF statements in Calculated Columns of a list. That blog has many tutorials based on Calculated Columns so you might be able to figure something out. I personally havent filtered based on that but I have added CSS.

I think another way to accomplish this is through list views? For example if you have 2 categories, Self Help and Other Help and the documents are split into these categories, you can create 2 views:

View 1: Filter by Self Help (should be an option on the edit view page)
View 2: Filter by Other Help (should be an option on the edit view page)

*Note: If you have a lot of categories this might not be the best idea as you would have to create a lot of views...

Now when viewing the list the user can select which view to see from the top ribbon, so basically its filtering using views.

Those are just two ideas that I can think of right now...give it a try!

share|improve this answer
Thanks very much! Will give it a go :) – Charles Baker Oct 3 '12 at 12:25

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.