Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
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
-
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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 468 Global Discussions
- 156 Industry Talk
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 521 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hi there! I'm working on an inventory of documents. The formula I want is one that would enable me to determine the last time a resource was updated. It'll use a checkbox column. Below is a list of wh…
- I saw someone else asked the same question in another thread https://community.smartsheet.com/discussion/108384/including-a-comma-for-currency-within-an-existing-formula but the answer was very confus…
- I created the formula below and it is working for the section that says "Validations - Issue Validations" and "Validations - Regulatory Issue" part and I can't figure out why =IF([Risk Activity]@row =…