Help

Re: Combining fields when some are sometimes empty

Solved
Jump to Solution
463 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Alba_Machado2
7 - App Architect
7 - App Architect

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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: