Hi I am not sure it is an IF formula or a switch formula that I need but I cannot work this one our for love nor money.
So I am trying to write a complex risk assessment and within it is a simple single select column where my options are
What I was hoping to do is have a column next to it that converts the different options into numbers 1-5 (which I would then hide but use in calculations.) There are lots of different versions of this within the base but for the life of me I cannot work out how to take the select options and get it to return a number am I going crazy? Any help greatfully recieved xx