IF Formula Issue


Hey all!

This is so simple but having issues. I want to show "1" "2" or "3" for "Low" "Medium" "High"

=IF([Level of Change]@row, = Low, "1", IF([Level of Change]@row, = Medium, "2", IF([Level of Change]@row, = High, "3")

What am I missing?!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!