IF Statement to set a symbol to a value - #Incorrect Argument set

bday2329 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Good Day,

I am trying to set a Symbol value using this IF statement but I get a "#Incorrect argument Set

=IF([Prev Year Difference]3, =0, "Unchanged", IF([Prev Year Difference]3, <0, "Up", "Down"))

The column/cell that I am using the formula in is defined as a "Symbol" using the "3 Direction" Up, Down & Unchanged. See attached.

I can get the following formula to work

=IF([Prev Year Difference]3 < 0, "Down", "Up")


Any help is appreciated!

Thank you in advance

If statement for Symbols.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!