0

I have one custom list built in sharepoint 2010 which is choice column.

The Datas of the list are

1.ABC

2.CDE

3.DEF

4.DFG

5.VFG

I need only numbers be automatically fills that in column when adding new item in the list.

for e.g: if i select "1.ABC",I need to fill that column field as only 1,

if i select "2.CDE",I need to fill that column field as only 2,

if i select "3.DEF",I need to fill that column field as only 3,

if i select "4.DFG",I need to fill that column field as only 4,

if i select "5.VFG",I need to fill that column field as only 5,

How can i achieve my requirement?

Please Help

Thanks in advance.

1 Answer 1

0

Simplet approach is to just have the values you need in the column and put the ABC, DEF, etc in the help description for th users to relate the two together.

Otherwise, you'll need a second "calculated" column to strip out the number OR you are looking at a code based option.

2
  • I need to go with second "calculated" column. May i know how to achieve this using formula.
    – user876869
    Nov 20, 2013 at 10:26
  • If your column is called "ChoiceCol" then the calculated column formula would be =LEFT(ChoiceCol,1) or if the text is not as described above, maybe you'll need to split the string. From the example above, this will work though.
    – Paul Leigh
    Nov 20, 2013 at 10:37

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.