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