Formula for selecting correct Image

Hey folks looking for IF statement that would allow me to specify a number ranges from one cell that contains a number to then display the appropriate Arrow. Any help in changing the formula would be great. Below is not correct but hopefully gives you the idea


=IF([Heat#]1 <= 4, "Down", 

IF([Heat#]1 <= 8, “Angle Down”, 

IF([Heat#]1 <= 10, “Sideways”, 

IF([Heat#]1 <= 12, “Angle Up”, 




  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Your formula was set up correctly, except for a couple of issues: 

    1. It looks like your formula was set up in a word processor as there were "Smart Quotes" in your formula. Smartsheet doesn't like smart-quotes and will throw an unparseable formula. Always compose your formulas in a simple text editor like Notepad or Notepad++. Word processers tend to substitute simple quotes for Smart ones. 
    2. You didn't have the right number of parenthesis to close you formula. You need one closing parenthesis for each IF you used. A little trick that is good to know with Smartsheet is if you delete ALL of the closing parenthesis, it will add the correct number for you. wink

    Here is a working formula. I also updated it to work with any row by using the @row indicator which takes the number for the current row and replaces it. Very handy for copying and pasting into several different rows. 

    =IF([Heat#]@row <= 4, "Down", IF([Heat#]@row <= 8, "Angle Down", IF([Heat#]@row <= 10, "Sideways", IF([Heat#]@row <= 12, "Angle Up", "Up"))))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!