Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Combining fields when some are sometimes empty

Topic Labels: Formulas
Solved
Jump to Solution
231 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Grateful to those in this community who helped me set up my family’s bookstore inventory. It’s going well and I often recommend Airtable to others.

So now I’m using this formula…

Title & " • " Author & " • " Place & " • " Date

But because a number of books do NOT indicate author, place, or date, I sometimes end up with this:

Title • • • Date

That’s not great for catalogs. Is there a formula I can use that will leave off the extra bullet(s) when one or more of the fields are empty?

1 Solution

Accepted Solutions

You can just do a simple IF() statement before each field to check if it exists.

So you can do this:

Title & IF(Author, " • " & Author) & IF(Place, " • " & Place) & IF(Date, " • " & Date)

See Solution in Thread

3 Replies 3

You can just do a simple IF() statement before each field to check if it exists.

So you can do this:

Title & IF(Author, " • " & Author) & IF(Place, " • " & Place) & IF(Date, " • " & Date)

Yay! ScottWorld for the win! Thanks so much! :grinning:

Haha, you’re welcome! Glad I could help! :slightly_smiling_face: