ansaurus

Question

Answer 1

+1 A:

Try something like this:

=IF(SourceColumn="Major",3,IF(SourceColumn="Moderate",2,1))

Toni Frankola 2009-10-02 13:34:14

Maybe I was incorrect in how I meant to complete my task but perhaps I don't need to use a calculated column in SharePoint. I'm not sure how to do this but what I would like to do is create a column that would appear to the user as a drop down list but the column would store a value that I would assign to each text value. This column would then be used in a calculated column that would use the numerical value to make a calculation and I think this is what your formula accomplishes. Do you know how I would create a column that would record a number but display as a drop down list?

Andy 2009-10-02 14:31:35

Sure. You can create a simple numeric column and then customize EditItem.aspx with SharePoint Designer. It is pure HTML, just add simple drop down... it requires some skill if you haven't tried that already.

Toni Frankola 2009-10-02 17:14:10

Do you know of a good resource that shows how to do this type of thing? I'm just not sure how to make those changes. I have SharePoint Designer but I'm not sure how to make those changes to a list form web part. Would I have to change the list form web part to custom list form? Thanks for all your help by the way. I couldn't find any good resources anywhere on my problem.

Andy 2009-10-02 18:40:19

Start with this one: http://office.microsoft.com/en-us/sharepointdesigner/HA101191111033.aspx

Toni Frankola 2009-10-02 18:58:03

ansaurus

tags:

views:

answers:

Calculated Column formula

related questions