ISBLANK() returns true if 0

Feedback
,
1

It seems that the ISBLANK() formula function returns true if the cell equals the number 0 (which is not blank)

2

Hi @Alex-Clapp, you are absolutely right. I have created a GitLab issue for this which you can track here: ISBLANK returns true if the number = 0 (#3719) · Issues · Baserow / baserow · GitLab

Thanks for your report :pray:

1 Like
3

After discussing the issue internally, it appears this is infact the intended outcome. For referece, Airtable also evaluates a 0 as a blank record with a number field.

A workaround you can use though would be to convert the field to text and then evaluate if it is blank which should return the expected result you’re after isblank(totext(field('Number'))) or alternatively use the is_null() function instead. (Only use is_null for a number field in this context)

4

ok, got it, thank you for the explanation!