I'm trying assign a number to the $ symbol.

I'm using this formula:

=IF(6_state_$ = "Empty", 0, 6_state_$ = "One", 1, IF(6_state_$ = "Two", 2, IF(6_state_$ = "Three", 3, IF(6_state_$ = "Four", 4, IF(6_state_$ = "Five", 5, 0))))))

But it comes back with unparseable. What am I doing wrong?

Thank you in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!