Skip to main content

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?

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

Hi.
Airtable is more flexible))

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

Terms & ConditionsAccessibility statement