How to create this Airtable formula with an IF condition

612 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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?

2 Replies 2
7 - App Architect
7 - App Architect

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.”

Airtable is more flexible))

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