Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to create this Airtable formula with an IF condition

156 2
Showing results for 
Search instead for 
Did you mean: 

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

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