I have choice selection within a column like 1-Easy, 2-difficult, 3-Impossible. I want to do a calculated field based on the selection, pulling the first character of the string (in these cases either 1,2 or 3) and convert them to numbers inside a calculated field calculation. The numbers are the weighting to be used in down stream calculations. I tried Value(Left[Column Name],1)) but it errors out. I also found some SP sites that say you can not use the Value function in a calculated field, so is there another way to accomplish this?
1 Answer
As shown in the screenshot below, Left([Column Name],1) should work if the Date Type of the Calculated Column is set as Number. Also, INT([string number]) function can be used in calculated formulas to convert valid string of Numbers to INT values.
For more info, see Calculated Formulas.
