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

  • 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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!