IF Statement to set a symbol to a value  #Incorrect Argument set
Options
bday2329
✭✭✭✭
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
Comments

Try removing the comma after the 2nd cell reference...

Thanks Paul..... I will get my eyes checked immediately

Haha. Happens to everyone.
Happy to help though.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!