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.)