Formula based on a symbol column

Cheryl Collins
Cheryl Collins ✭✭✭✭✭✭
edited 01/05/21 in Formulas and Functions

I have a symbol column and want to add a score in another column based on the symbol. I am currently using the following formula but am getting an #INCORRECT ARGUMENT error.

=IF([Risk Management]@row, "Up", 3, IF([Risk Management]@row, "Unchanged", 2), IF([Risk Management]@row, "Down", 1))

I've solved it myself now. :-)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!