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.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/645fbad0-e37f-4cac-a141-43da5ed4e2e6.png)
Best answer by Troy Tessalone
View original