"IF" formula for a score range

Lisa Matthews2

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

Malaina Hudson

@Lisa Matthews2 ,

#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

Thank you, @Malaina Hudson

That fixed the problem!! Extra parentheses was the problem.

:)

Malaina Hudson

@Lisa Matthews2 Great! Glad that helped!

Malaina Hudson

@Lisa Matthews2 ,

#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

Thank you, @Malaina Hudson

That fixed the problem!! Extra parentheses was the problem.

:)

Malaina Hudson

@Lisa Matthews2 Great! Glad that helped!