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

Question

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.

Best answer by ScottWorld

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

ScottWorld · Accepted Answer

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

Caitlyn10 · Answer

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 😀

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded