Lookup field showing "0" as blank

Topic Labels: Formulas
88 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I have a lookup field in table A that is supposed to retrieve values from a number field on table B.

Some of the values on table B are 0. Currently the lookup field on table A is showing blanks for all 0 values.

0 is different than blank. For my purposes, blank means missing information and 0 means 0.

How do I fix this? I have a feeling that if I changed the table to a text field it would help, but I have some integrations with accounting software and would rather not do that if I don't have to as it may muddy some other things.

1 Reply 1

Airtable sometimes considers blank and zero to be equivalent.

How is your lookup field configured? Can you post screen shots of your lookup configuration and of your data (including the related linked record field)?

If you are setting a condition for where the field "is not empty", it should include zero, but not blank.