I've got a SP drop down column which contains options like:
- Doesn't align to current priorities
- Somewhat aligns to current priorities
- Aligns strongly with current priorities
I want to assign all of these a numerical value so in this case:
So that these values can be used in a calculated field later. What's the best way of achieving this?
Thanks in advance.