IF Function help

Mike Norman
Mike Norman ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I am attempting to use a nested IF statement that assigns a number based on a dropdown selection.

Example: User chooses "Medium" in the Impact column, and I'd like to assign a value to that selection in the next column.

=IF([Care Training Impact]1 = High, "60", IF([Care Training Impact]1 = Medium, "35", "2"))

I receive an 'unparseable' error. Any thoughts on what can be done to return what I am looking for?

Comments