Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm using SharePoint 2007 and I'm working on a List in a DataSheet view.

I created the field "Color" - a dropdown field that contains: "Yellow","Green","Blue". I also created the fields: "YelloFruits" - a dropdown field that contains: "Banana","Lemon","Pineapple". "GreenFruits - a dropdown field that contains: "Apple","Kiwi". "BlueFruits - a dropdown field that contains: "Blueberries".

I need to create a calculated field to behave as follows: IF the "Color" field is equal to "Yellow" THEN present the dropdown field "YellowFruits" ELSE IF the "Color" field is equal to "Green" THEN present the dropdown field "GreenFruits" ELSE IF the "Color" field is equal to "Blue" THEN present the dropdown field "BlueFruits".

Hope it is clear enough.

Thanks, Dror.

share|improve this question

2 Answers 2

Calculated columns don't work that way. Calculated columns set values based on information from other columns, not toggle visibility of form fields. The closest thing I can think of that you're wanting to do is a cascade dropdown, filtered options in a drop down list based on the selection of a previous column.

The datasheet view cannot handle that to my knowledge, but if you create a single item New/Editform using the SPServices library, you can achieve that functionality with the SPCascadeDropdowns function and jQuery..

share|improve this answer

I don't think that what you want is possible. The DataSheet view is an build-in component (made available if the client has Access installed).

If you want special functionality (business logic) in your edit/new forms you have to roll your own.

share|improve this answer

Your Answer

 
discard

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.