If/Then Statement with Symbols

I'm having hard time to get this formula to work:


=IF(Amount@row < 0, "Red", IF(Amount@row > 0, "Green"))

See attached Error. I want to show a red dot when the amount is negative and a green dot when an amount is positive.

Thanks,


Amy

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!