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

Reply


Terms & Conditions