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

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

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.

Thank you!

Help Article Resources
Categories
Check out the Formula Handbook template!