Solved

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

+3

Imagine that I have three different fields.

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

Best answer by Databaser

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

+25

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

Jan - Databaser

Sign up