Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Using If with a blank option

Topic Labels: Formulas
512 1
Showing results for 
Search instead for 
Did you mean: 

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