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

Concatenate fields with comma, except when fields are empty

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

Hello, I am trying to concatenate 4 fields into one field with commas in between each field, only when the fields have a value in them (ie. no comma for empty fields). I’m using the below formula successfully to combine 2 fields, excluding the comma when a field is blank. But, I don’t know how to lengthen this formula to cover 4 fields. My 4 fields are, “Building,” “City,” “State,” & “Country.” I’ve tried several variations and can’t figure this out.

=IF(OR(Building=BLANK(),City=BLANK()),CONCATENATE(Building,City),CONCATENATE(Building,", ",City))

Thank you for any help you can provide!

1 Reply 1

Answered in this other thread.