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
= 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!