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!