#Unparseable with If statement

aaboueid

I keep getting # Unparseable error with this if statement:

=IF(RC@row= “RFI-1”, "*Request For Information*”

,IF(RC@row = “RFI-2”, “**Request For Information, Second Attempt**”

,IF(RC@row = “RFI-3”, “***Request For Information, Final Attempt***”

,IF(RC@row= “IFA-1”, "*Request For Approval*”

,IF(RC@row = “IFA-2”, “**Request For Approval, Second Attempt**”

,IF(RC@row = “IFA-3”, “***Request For Approval, Final Attempt***”))))))

What am I missing?

 

Thanks in advance

Mike Wilday

Try pasting your formula into a notepad or notepad type text editor so that your quotes get sorted out. 

It appears that your quotation marks are smart quotes instead of standard straight quotes. This frequently causes issues with formulas in smartsheet. Retyping all of your quotations might help the cause. Notice that your quotes are slanted in comparison. 

Unslanted " 

Slanted ”

aaboueid

Thank you Mike, I will give that a try.

aaboueid

It worked perfectly after changing the quotes, thanks again!

Mike Wilday

Absolutely! Never use a word processing program like microsoft word to write out your formulas as they always convert your quotes to smart quotes which causes quite a headache in these circumstances.