I have this question regarding creating a calculated column in SharePoint. My problem is that I need a column that will display text values in a dropdown list and once the user selects one of the text values, a number value will be assigned to each text value and will be stored in the field to be referenced by another calculated column.
So the text values would have the following values:
Major - 3 Moderate - 2 Minor - 1
Is there anyway to do this with one sharepoint column? Any help would be much appreciated. Thanks.
