Help

Concatenating without zeros or blank fields

Topic Labels: Formulas
Solved
Jump to Solution
1418 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lainie_Elton1
4 - Data Explorer
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 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!