Hello I have been using Smartsheet for quite a while however I am really stuck on this formula. I've been searching and reading and none of the things I have found work and I'm thinking it should be this hard. I'm obviously missing something.
I have 2 columns with scores in them (that had been calculated using another field) ie if the Answer is Low the answer is 1 on the column called Score1, then if the likelihood is high the answer is 5 on the column called Score2.
A third column called Total Score is the total of Score1 multiplied by Score2 ie 2 x 6 = 12
So what I now need to do is create a formula that says if the Total Score Column is <4 answer is Low, if the score is between 4-10 answer is Moderate, if the score is between 10-15, and is High and if between 15-20 answer is Extreme.
For the life of me I cannot get this to work, can anyone assist me.
