If/Then Statement with Symbols

Amy Evans

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

Error.png

=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

Paul Newcome

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.

Paul Newcome

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.

Amy Evans

Thank you!

Paul Newcome

Happy to help. 👍️