Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

# Re: Concatenating without zeros or blank fields

Solved
95 0
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi! There is probably a very simple solution to this, but I’m trying to create a field that shows information from EITHER of two other fields - whichever one happens to be populated. My issue is that they are both calculated number fields, so I’m getting zeros instead of blanks.

Example:

# of Jars (SOUP B) = 0

Ideally Field C should just be “3” but instead I end up getting “30” because I don’t know the proper “IF” formula to wrap into it.

Here is my current formula:
CONCATENATE({# of Jars (A)},{# of Jars (B)})

Any assistance would be much appreciated!
Thanks!

1 Solution

Accepted Solutions
4 - Data Explorer

BRILLIANT! This worked perfectly! Thanks so much!

2 Replies 2
14 - Jupiter

A value of `0` in a number field is considered a “falsey” value, so the `IF()` check for that is actually very simple (and I’m using the concatenation operator (`&`) instead of the `CONCATENATE()` function to further simplify your scenario)…

``````IF(
{# of Jars (A)},
{# of Jars (A)}
) &
IF(
{# of Jars (B)},
{# of Jars (B)}
)
``````
4 - Data Explorer

BRILLIANT! This worked perfectly! Thanks so much!