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?

  • Is there any reason the second column is a DropDown and not a simple calculated field? – banana Jun 18 '13 at 14:44
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

  • 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 '13 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 – Ranjoe Santos Jun 18 '13 at 9:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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