Best answer

"Invalid Syntax: Only numeric values are allowed" when using an IF function

I’m using an IF formula to return value A (“Internal”) or value B (“Public”) depending on what a cell looks like in my Google Sheet.

The error I get is “Invalid Syntax: Only numeric values are allowed”.

I saw a similar post about using JavaScript code, but I’m not sure if this is the correct solution for me let alone how to implement.

Best answer by Troy Tessalone

Hi @Lauryn

Try putting double quotes around the mapped variable.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+14

Hi @Lauryn

Try putting double quotes around the mapped variable.

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor

Sign up