Can someone help me with the IF/THEN formula?

Chrisanthi Linberg
Chrisanthi Linberg ✭✭
in Formulas and Functions

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

· Share on FacebookShare on Twitter

Answers

  • Meg Y
    Meg Y ✭✭✭✭✭✭

    @Chrisanthi Linberg

    This is my understanding. The score is one column and the criteria you want to return is a seperate column. If this correct try the formula below


    =IF(Score@row > 300, "Met", IF(Score@row > 100, "partially met", IF(Score@row > 1, "Did Not Meet")))

    ________________________________________________________________________________________________________________________

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    Meg Young mmyoungconsulting@gmail.com. Certified in Core Product, Project Management, and System Administration

    · Share on FacebookShare on Twitter
  • Chrisanthi Linberg
    Chrisanthi Linberg ✭✭

    Hi Meg - thank you for this help. I entered the formula and am getting the below message. I'm not good with formulas at all so I'm sure it's me.


    image.png


    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!