"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!