I have two columns (for example column A and column B) with the type of information as choice. When i select value in column A then column B should show values related to column A only. Other values from column B should not be visible. How can I create rule for this?

2 Answers 2


That type of functionality can't be achieved with calculated columns. You are going to have to use JavaScript/jQuery on the editform.aspx page of your document library to get that. Fortunately there is a library called SPServices that has a function specifically for cascading choice fields.

Cascading dropdowns


Hope following article will guide you to achieve the functionality you want to implement.


  • Hi Anuja! Please add the details from the link to you answer. If the link breaks, your answer will be of no help as it is written now. Nov 15, 2013 at 7:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.