Using If with a blank option

Topic Labels: Formulas
977 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to get the following result and I don’t know how to use the if function for that.

If (record is blank), CONCATENATE(a&b), CONCATENATE(b&c))

What should I do?

1 Reply 1

What fields in the record are blank? If A, B, and C are fields in the record, then there would be nothing to concatenate. If they are not fields in the record, you don’t need a formula.

If you you have specific input fields that would be blank, and other fields that would not be blank, you can create an if statement with those.

IF( AND({Input 1} = BLANK(), {Input 2} = BLANK(), {Input 3} = BLANK())
  A & B,
  B & C