Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Numbers and currency fields treat blank as 0

Topic Labels: Formulas
Solved
Jump to Solution
2485 2
cancel
Showing results for 
Search instead for 
Did you mean: 
OneKlinik_Admin
4 - Data Explorer
4 - Data Explorer

I want to show a message if a number field is blank. 0 is a valid, non-blank entry. I’m using the formula
IF({Number}=BLANK(),"Blank","Not Blank")
where {Number} is an integer. What I’m seeing is that blank values and 0 values are treated the same in this formula. That is, the formula field shows “Blank” for both empty values and 0 values. I would expect this to show “Not Blank” for 0 values.

Screen Shot 2021-03-19 at 2.13.51 PM

Screen Shot 2021-03-19 at 2.13.58 PM

Conditional formatting will highlight only the empty values, which is what I would expect. So the concept exists.

Is there something missing or is this a bug? Any workarounds?

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community. This is a known issue. The workaround is to convert the number into a string, and then test based on that.

IF( {Number} & "", "Not Blank", "Blank")

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community. This is a known issue. The workaround is to convert the number into a string, and then test based on that.

IF( {Number} & "", "Not Blank", "Blank")

Thank you! That will solve my issue!