Formula for scores between two numbers

edited 12/09/19 in Formulas and Functions

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!