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.



Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try going ahead and clicking the "Allow" button. That just means the column is restricted to only allow the manual selection of the symbols. Since a formula is technically not one of the "built in" options of the symbols column, it is just alerting you to the column properties.

    If I am applying a column formula, I usually turn off that restriction since it is a bit on the annoying side and column formulas block manual entry anyway.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!