Nested IF statement in Smartsheet

Hi,

I need help with an IF statement using SMARTSHEET.

I've attached an image of the two columns in question.

~ Risk Impact (text)
~ Risk Impact Score (value of returning function)

This is what formula i used, but it isn't liking the text. Can someone please help me here.

My Formula: =IF([~ Risk Impact]1 = “No Impact“, 1, IF([~ Risk Impact]1 = “Low Impact“, 2, IF([~ Risk Impact]1 = “Medium Impact”, 3, IF([~ Risk Impact]1 = “High Impact“, 4, IF([~ Risk Impact]1 = “Very High Impact“, 5)))))

I thought the above would have worked.

Thanks in advance for your help.

I know nothing about SMARTSHEET but are you able to post a file here?

It is a smartsheet application on the cloud, I cannot attach a worksheet.

I can give you a link to their site, which shows what formulas I am limited to: http://help.smartsheet.com/customer/...using-formulas

Thanks

Hi,

I don't have any experience of Smartsheet either, but it looks to me like you're missing your last 'value_if_false' statement. Try this:

Formula:

Please Login or Register  to view this content.

You've also got a mix of quotation marks - “ after some text, ” after others. Try retyping it in plain text to get rid of those - some programs won't parse non-straight quotation marks.

Regards,
Aardigspook

Hi Aardigspook,

Thanks, you are correct, i was missing the last Value_if_False

Legend

Regards.

You're welcome.

Regards,
Aardigspook

If your problem is fixed, please mark your thread as Solved (Go to the top of the first post, select Thread Tools, select Mark thread as Solved).

Hello yguzel! Sounds like you were able to figure it out but a couple notes... A 'value_if_false' isn't always necessary and in this case, you do not need it. Its fine to have one, but it is not the cause of the error you were getting. I copied this formula into one of my sheets and received an #UNPARSEABLE error. Oddly enough, what fixed this was for me to go in and replace all your quotation marks with new quotation marks. After I did that, the formula worked like a charm! Did you build the formula outside of Smartsheet then copy it in? It may be possible the characters were messed up in the transition into Smartsheet.

Happy to see you were able to get this working! If you need anything else, feel free to email the support team at [email protected]

Thanks!

Travis
Smartsheet Community Manager