Help

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.

Concatenating without zeros or blank fields

Topic Labels: Formulas
Solved
Jump to Solution
390 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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 A) = 3

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

BRILLIANT! This worked perfectly! Thanks so much!

See Solution in Thread

2 Replies 2

Hi @Lainie_Elton1,

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)}
)

BRILLIANT! This worked perfectly! Thanks so much!