Introducing single-select output for formula field...

[Quinn_Ballard]

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!

[David_Skinner]

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.

[Quinn_Ballard]

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 = ’ ’