"IF" formula for a score range
Hello,
I'm looking for some help with an IF formula to assign a text value in one column based on a score range from a different column.
Thank you in advance for helping me figure out how to write this so that it works in the Smartsheet.
Lisa
Best Answers

#UNPARSEABLE is most frequently caused by an imbalance in your ( and ). Try removing one ) from your formula and see if this fixes the error. Also keep in mind on nested IF statements that it will stop looking to solve when it hits the first TRUE in the conditionals. Your current nesting seems to be correct and works in my testing.


@Lisa Matthews2 Great! Glad that helped!
Answers

#UNPARSEABLE is most frequently caused by an imbalance in your ( and ). Try removing one ) from your formula and see if this fixes the error. Also keep in mind on nested IF statements that it will stop looking to solve when it hits the first TRUE in the conditionals. Your current nesting seems to be correct and works in my testing.


@Lisa Matthews2 Great! Glad that helped!
Help Article Resources
Categories
Check out the Formula Handbook template!