"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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!