Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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
1159 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Caitlyn10
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}
))

Caitlyn10
6 - Interface Innovator
6 - Interface Innovator

You're amazing, thank you! Problem solved ðŸ˜€