Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Number Range Logic
I am trying to craft a formula that sources a numerical value in a different column and, based on that value, prints a skill level. Here's the formula:
=IF([Points]1 <99, IF([Points]1 <199, “Apprentice”, IF([Points]1 <499, “Amateur”, IF([Points]1 <999, “Pro”, IF([Points]1 <1999, “Veteran”, IF([Points]1 <= 3999, “Expert”, IF([Points]1 = 4000, “Master”)))))))
I keep getting the #UNPARSEABLE error. I have searched the forums for and found good ideas on how to make this work however, none of it seems to work for me.
Any ideas on what I'm missing?