Skip to main content

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.

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

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  😀

Reply


Terms & Conditions