Gallery
Kuovonne's Guide to Airtable
Share
Explore
Kuovonne's Guide to Airtable
Specific Formulas

Comma Separated List of Fields Values with Optional Fields

Thank Kuovonne for creating this content!

Inspiration

You want to combine text from multiple fields into a comma separated list. But some fields are optional, and you do not want any extra commas.

Discussion

You can combine text from multiple fields into a comma separated list, without extra commas when optional fields are empty.
image.png
REGEX_REPLACE(
CONCATENATE(
IF({City}, {City} & ", "),
IF({State}, {State} & ", "),
IF({Country}, {Country})
),
", $",
""
)


Thank Kuovonne for creating this content!
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.