Don’t know why this formula is returning #UNPARSEABLE

Hi,

This is probably really basic and I’m sorry if it is, but I’ve been tearing my hair out over WHY SmartSheet is complaining about this formula:

=IF(AND([Raised by]@row<>”My Name”,[Raised by]@row<>”my.name@mycompany.com”),[Raised by]@row)

So - return the column “Raised by” in this row, if it’s not “My Name” and not the email version of “My Name”.

It worked fine without the AND, but I am flummoxed as to why it now has a problem. Before you ask - yes - I’ve tried manually reconstructing the formula by removing and re-adding the cell references with the cell value in the row. Furthermore, it seems to recognise each syntactic element in the expression(s) correctly, so I just cannot see the problem here. I hope someone can.

Thanks,

GAM

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

@gamgc

Strange! You usually don't get the slanted "" in Smartsheet, only in a word processor such as Word or similar.

The formula works in my sheet.

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

All comments

Andrée Starå

Hi @gamgc

I hope you're well and safe!

Try something like this.

=IF(AND([Raised by]@row<>"My Name",[Raised by]@row<>"my.name@mycompany.com"),[Raised by]@row)

Did that work?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

gamgc

Hi Andree,

Thanks, but that didn’t work, and I don’t see how it is syntactically different to my formula.

Thanks,

GAM

Andrée Starå

@gamgc

Happy to help!

The difference is in the "". Yours was slanted because you probably wrote the formula in a word processor. Correct?

Did you copy and paste my formula? If you did and it didn't work.

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

gamgc

Hi Andree,

No - I didn’t write my formula in a Word Processor. I typed it directly into the cell.

I copied your formula into a TextEdit on my Mac, adjusted it for my specific variable names and pasted it into a cell in the sheet and it didn’t work.

Thanks,

GAM

Andrée Starå

@gamgc

Strange! You usually don't get the slanted "" in Smartsheet, only in a word processor such as Word or similar.

The formula works in my sheet.

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

gamgc

Hi Andree,

Thanks very much for pointing me to the solution. For some reason, I had an unknown/invalid Input method selected; i.e “ABC”, viz:

That was causing the slanted/curved quotes to be used. Deleting that and replacing with the correct Australian input method fixed the issue.

Thanks again,

GAM

Andrée Starå

@gamgc

Excellent!

Happy to help!

That's a new reason for the slanted ones that I wasn't aware of.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.