Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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