New answers tagged choice-field
The default SharePoint Priority field has the (1) Low, (2) Medium, (3) High notation for the labels, that makes it easier to extract the value and your fourth Calculated Column slims down to: =RIGHT(LEFT([Col1],2)) * RIGHT(LEFT([Col2],2)) * RIGHT(LEFT([Col3],2))
Yes this is possible. You can make 3 Calculated columns to spit out the number value of each of the three columns you talk about, and then have the 4th Calculated column use those values. Or You can make a long formula for your 4th column to first determine the corresponding value of "High", "Medium", "Low" for each column before multiplying the ...
Top 50 recent answers are included