IF Function help

Mike Norman

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?

Mike Wilday

High and Medium should be in quotes like this: 

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

Also, if you want those values to be actual numbers... remove the quotes around the numbers like this... 

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

That way the numbers won't be converted to text and will be able to be summed or used in calculations without converting them back into numbers. 

L_123

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

Mike Norman

Thanks, I finally have a number showing!

Issue now: When I change the dropdown value from Medium to High, Low or None, the number doesn't change. Anything I'm missing?

Mike Wilday

Try adjusting your formula to this: 

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

It might be that your formula is still looking at row 1 but you've placed it in a different row. 

Mike Wilday

Adding @row instead of a specific row number will look at the columns for the current row you are on. 

• https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

Mike Norman

This worked perfectly, thank you!!

Mike Wilday

Great! I'm glad I could be of assistance.