Help

Fallback to the 2nd then 3rd field, if the 1st priority field, isn't filled in, for my formula

Topic Labels: Formulas
Solved
Jump to Solution
628 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Adisa_Nicholson
5 - Automation Enthusiast
5 - Automation Enthusiast

Imagine that I have three different fields.

  1. Disboard URL
  2. Top.gg URL
  3. Official invite URL

How do I make it so if a field isn't found in the formula, it'll fallback to the next one of lower priority.

For now I would like my formula to lookup three fields.

Here's what I've got so far but it only works with two fields.

IF({Disboard URL}  + {Top.gg URL}='' ,BLANK(), {Disboard URL})

 

1 Solution

Accepted Solutions
Databaser
12 - Earth
12 - Earth

If Disboard is the most important one, and Official invite the least important one, try:

IF({Disboard URL}, {Disboard URL}, IF({Top.gg URL}, {Top.gg URL},{Official invite URL}))

See Solution in Thread

1 Reply 1
Databaser
12 - Earth
12 - Earth

If Disboard is the most important one, and Official invite the least important one, try:

IF({Disboard URL}, {Disboard URL}, IF({Top.gg URL}, {Top.gg URL},{Official invite URL}))