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!
