Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

If field is blank use other field, but if that second field is blank then use a third field

Topic Labels: Formulas
Solved
Jump to Solution
658 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Caitlyn_Irwin
6 - Interface Innovator
6 - Interface Innovator

Hi there, I'm essentially trying to set up two overwrite fields in my formula. So if field 1 is blank, then use the data from field 2, but if field 2 is blank, then use data from field 3.

I have the formula for one overwrite which works fine (see below), but I can't seem to work out how to add another condition to it.

 

IF({Company Invoice Contact}, {Company Invoice Contact},Company)
 
I want it to work like;

IF Invoice Contact Overwrite is blank then use Company Invoice Contact but IF that is blank, then use Company. 
 
Any help would be much appreciated.
1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

I haven’t tested this, but you should be able to do it like this:

IF( AND({Field 1}="",{Field 2}=""), {Field 3},
IF( {Field 1}="", {Field 2},
{Field 1}
))

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

I haven’t tested this, but you should be able to do it like this:

IF( AND({Field 1}="",{Field 2}=""), {Field 3},
IF( {Field 1}="", {Field 2},
{Field 1}
))

You're amazing, thank you! Problem solved 😀