How to create this Airtable formula with an IF condition

+4

Hey there, I want to create a formula for a that says

If {first name} and {email} column exist then put the word yes and if not then nothing

Is this possible?

+18

Welcome to the community!

I’m no expert, but this formula should do what you’re describing:

IF(OR({first name}="",{email}=""),"","yes")

If either the name or the email is blank, it will return nothing, but if both are full, it will return “yes.”

+25

Hi.
Airtable is more flexible))

If(AND({first name},{email}),‘yes’)

Sign up