Airtable Combining and Formatting Multiple Select Columns

Grateful to those of you who’ve helped me get started on Airtable. I recently realized I’ve been leaning too hard on you folks, so I’m making sure to research my Airtable problems as much as I can before heading here. I think I’m getting a handle on the IF formula, but not on the formatting within it. (In case anyone’s curious, aside from taking over my dad’s bookselling business, I’m also helping to get a nonprofit publication off the ground. That’s what this one is for.)

Here’s the formula that’s not working right:

IF(
{Community Causes},{Community Causes} & ", ",
" " &
IF(
{Democracy Causes},{Democracy Causes} & ", ",
" " &
IF(
{Economy Causes},{Economy Causes} & ", ",
" " &
IF(
{Health Causes},{Health Causes} & ", ",
" " &
IF(
{Identity Causes},{Identity Causes} & ", ",
" " &
IF(
{Justice Causes},{Justice Causes} & ", ",
" " &
IF(
{Nature Causes},{Nature Causes} & ", ",
" "
)))))))

And here’s what that renders (missing values):

(I’m also curious about how to copy/paste formulas here so they’re easy for readers to spot like the pros do.)

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.