Welcome!

IF Function help

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?

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.

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

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?

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.

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

This worked perfectly, thank you!!

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

Suddenly View Only on all Workspaces and Sheets I own
This discussion was created from comments split from: I am an editor on a smartsheet but can't edit the sheet.
Sharing with Editors outside our company
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
How to create stack column graph bars
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…