0

I have created a custom list in sharepoint 2010 which contains two columns.

One column is single line of text.

Second column is dropdown which contains 4 values (q1, q2, q3, q4).

  • If the text of first column contains as( jan or Feb or Mar) the dropdown should automatically select as q1.
  • If the text of first column contains as( Apr or may or jun) the dropdown should automatically selected as q2.
  • If the text of first column contains as( jul or Aug or Sep) the dropdown should automatically select as q3.
  • If the text of first column contains as( Oct or nov or dec) the
    dropdown should automatically select as q4.

How can I achieve this requirement?

1
  • Is there any reason the second column is a DropDown and not a simple calculated field?
    – banana
    Jun 18, 2013 at 14:44

1 Answer 1

0

you can consider making your first field as dropdown as well and make this 2 dropdowns as cascading dropdown. here is a good Reference

2
  • Hi Ranjoe, Thanks for your Valuable information.But i could not able Change the single line of text column to dropdown.In the single line text colum, the user may enter as 8-Jan.if that fields contains Jan we need to assign as Q1.
    – madhan
    Jun 18, 2013 at 9:20
  • then try this link for that spjsblog.com/2010/06/15/… there is also a link that with his previous version. you can try to look into those and i think essentially those are the concept you are looking for Jun 18, 2013 at 9:30

Your Answer

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

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