#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

Find more posts tagged with

Formulas

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?