I am trying to test if a value is a number but every attempt results in FALSE, even if I hard code it to 1. I am sure it is something simple but I can’t see why this doesn’t work?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Community Manager
- 9736 replies
Hi
The = sign shouldn’t be needed in the formula. That said, I did some testing on my end and couldn’t get it working with ISNUMBER(1) either. I’d recommend reaching out to our Support team for further investigation in case it’s a bug. You can contact them via: https://zapier.com/app/get-help
In the meantime, could you tell us a bit more about how you’re how you’re using the formula in your workflow? If we can get a bit more context on the overall workflow, we might be able to suggest a workaround.
Looking forward to hearing from you! 🙂
+14- Zapier Orchestrator & Solution Partner
- 34072 replies
Hi
Here are possible workarounds:
- Action: AI by Zapier - Analyze and Return Data
- Action: Code - Run JavaScript
const X = inputData.X;
// Check if X is a number
const isNumber = !isNaN(X) && X !== null && X !== '' && isFinite(X);
return { isNumber };
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.