Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Getting Formula to Run only if cell not blank

Topic Labels: Formulas
322 2
Showing results for 
Search instead for 
Did you mean: 

I’m trying to get a formula to run only when the cell has a value.

I work with hotels, so we send out weekly summaries of the entertainment scheduled for that week. I am creating a column that will automatically pull out the specific location (Venue) within that hotel where the performance is taking place.

This is the formula I am currently using (which works):

CONCATENATE("| ", {Venue (from Venue)})

Not all hotels have a specific venue name for the performance location. If the “Venue (from Venue)” field is blank, I would like to make it so this formula doesn’t even run.

I did some reading in the forums and tried the below formula (amongst others), but it isn’t working.

IF({Venue (from Venue)} = BLANK(), BLANK(), CONCATENATE("| ", {Venue (from Venue)})

Can someone help me? Thanks!

2 Replies 2

Hi Lowell. Have you tried…

IF({Venue (from Venue)}, CONCATENATE("| ", {Venue (from Venue)}))

This works. Thank you!