Can someone help me with the IF/THEN formula?

I have a sheet that has a column with a total score. If the score is between the ranges below I want a new column to reflect the label of met, partially met or did not meet.

Scoring Ranges and Criteria

301-500 = Met 

101-300 = Partially Met

less than 100 = Did Not Meet

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!