I’m using Formatter by Zapier, Spreadsheet style formula. The function ISNUMBER() does not seem to be working correctly.
I mapped a value to the function ISNUMBER({{=gives["*********"]["Val1"]}}) where Val 1 maps to a value 60647
The function returned False.
I tried again, hardcoding the number:
ISNUMBER(60647)
The function is still returning false.
This feels like a bug. Is there a known workaround?
Best answer by SamB
Hi there
I did some checking on this end and found a bug report for Formatter where the ISNUMBER formula is always outputting false, so I went ahead and added you to the list of folks being affected by that. I can’t give any sort of ETA on when it will be fixed but we’ll notify you by email as soon as it is.
In the meantime, perhaps you could try using a Code or AI by Zapier action to check whether the value in the field is a number.
Let us know if you run into any issues on those alternative actions, want to make sure you’re all set!
+14Hi
Try opening a ticket with Zapier Support: https://zapier.com/app/get-help
Help links for using functions in Formatter formulas: https://help.zapier.com/hc/en-us/articles/8496181204877-Available-spreadsheet-style-formulas
| ISNUMBER(value) | Returns TRUE if a value is a number; Otherwise, returns FALSE |
For us to have true context, post screenshots showing how your Formatter Zap step is configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.
Hi
Here's the Zapier doc that might help: link
If you're still running into issues, drop a screenshot of the error and a quick description of what your Zap is doing, happy to take a look!
And if you'd rather just get it sorted quickly, I offer a free 20-min Zapier troubleshooting call. Book it under Resources on my Zapier Directory profile: https://zapier.com/partnerdirectory/automatemybiz
!-->
+11Hi there
I did some checking on this end and found a bug report for Formatter where the ISNUMBER formula is always outputting false, so I went ahead and added you to the list of folks being affected by that. I can’t give any sort of ETA on when it will be fixed but we’ll notify you by email as soon as it is.
In the meantime, perhaps you could try using a Code or AI by Zapier action to check whether the value in the field is a number.
Let us know if you run into any issues on those alternative actions, want to make sure you’re all set!
Hi there
I did some checking on this end and found a bug report for Formatter where the ISNUMBER formula is always outputting false, so I went ahead and added you to the list of folks being affected by that. I can’t give any sort of ETA on when it will be fixed but we’ll notify you by email as soon as it is.
In the meantime, perhaps you could try using a Code or AI by Zapier action to check whether the value in the field is a number.
Let us know if you run into any issues on those alternative actions, want to make sure you’re all set!
Thanks for following up, I didn’t have time to do additional testing to post here. I did end up using code, but I’d prefer to use that as little as possible to make the Zap accessible for folks in my org that don’t know how to code.
Cheers
+11No worries
If it does, then a simpler way would be to use a Filter to only allow the Zap to continue if the word/phrase isn’t found. Could that approach work better?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
