Skip to main content
Question

ISNUMBER(60647) is returning false

  • March 27, 2026
  • 2 replies
  • 18 views

Forum|alt.badge.img+1

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?

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 27, 2026

Hi ​@BobbyA 

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.


Forum|alt.badge.img+2
  • Zapier Solution Partner
  • March 27, 2026

Hi ​@BobbyA 

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

!-->