Help

Re: Using IF and OR formulas to get a single output

Solved
Jump to Solution
1591 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Quinn_Ballard
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, I have had a lot of success using formulas in the past, but I am stumped on how to properly format the following:

I have three columns: Email, Phone, and Wants Follow Up?

I have been stumped on making a formula where IF the Email cell OR the Phone number cell is filled out (AKA not blank), then the output will be a YES in the Wants Follow Up? cell.

I know I must be making an simple mistake, because the formulas I have tried only give a YES output if both the Phone and Email cells are filled out, not either-or.

The actual OR formula as shown on the Airtable help section just outputs a 1, but I want YES text to be shown, not a 1.

What am I not doing correctly? Thanks!

11 Replies 11

Sorry, I hadn’t checked my formula before posting. I’ve accidentally deleted it now as well.

As Jonathan says, it seems you can’t use BLANK() as a comparison. I thought I had in the past, but perhaps not.

Cool, thank you both. That’s where I was getting really stuck – I didn’t realize that there were cases where = BLANK() might not work as opposed to = ’ ’