IF Statement between Ranges



I am not sure what i am doing wrong in the formula

=IF([Current Risk Score]@row < 15, "36 Months", IF([Current Risk Score]@row > 70, "3 Months", IF(AND([Current Risk Score]@row > 16, [Current Risk Score]@row < 29, "12 Months", IF(AND([Current Risk Score]@row > 30, [Current Risk Score]@row < 50, "6 Months"))))))

Essentially if "Current Risk Score" is between 1-15 review risk in 36 months, if in between 16-29 review risk in 12 months, if in between 30-50 review risk in 6 months, and if more than 70 in 3 months.

Any help is appreciated with this formula

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!