Getting Formula to Run only if cell not blank

Topic Labels: Formulas
707 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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
10 - Mercury
10 - Mercury

Hi Lowell. Have you tried…

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

This works. Thank you!