Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Airtable Combining and Formatting Multiple Select Columns

Topic Labels: Formulas
680 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alba_Machado2
7 - App Architect
7 - App Architect

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

Airtable Combining and Formatting Multiple Select Columns

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

0 Replies 0