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

[Caitlyn_Irwin]

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.

[ScottWorld · Accepted solution]

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

[Caitlyn_Irwin]

You're amazing, thank you! Problem solved 😀