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?