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

Background info - I'm a Business Analyst for a company providing shared cloud solutions to pharma clients. We use Sharepoint to track multiple things such as Action Items, Service Requests, etc.

As an end-user, I don't have developer access, but I have have access to create lists, libaries, etc with Windows Sharepoint Services (not sure of version - 3.0 or 2007?) That said, from doing extensive research I've learned that filtered (cascading) drop-down columns are not part of the product - that figures. Please bare with my newbie post.

Is it possible to work around this issue by using a nested IF-THEN type of statement with a combination of lookup and calculated fields? Here's a basic scenario to illustrate what I'm looking to do:

Custom List 1 (County)
Column 1 (County Name) - with 2 items:
1 = Morris
2 = Essex

Custom List 2 (Town)
Column 1 (County Name) - with 4 items:
1 = Morris
2 = Morris
3 = Essex
4 = Essex

Column 2 (Town Name) - with 4 items:
1 = Parsippany
2 = Randolph
3 = Newark
4 = Caldwell

Using a custom list (based on these lists above) if I choose Morris in one field, can I have the Town field show only the corresponding towns - Parsippany and Randolph?

share|improve this question
If you have MOSS 2007 - InfoPath can save your life! So make sure the version! – Arsalan Adam Khatri Nov 8 '12 at 23:31

You can take advantage of the SPServices jquery library on codeplex that will allow you to do such a cascade lookup/filtering... SPServices link here

share|improve this answer

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.