
1. Re: Help with an if/then formula for a field
Shelby Lovejoy Oct 11, 2016 8:09 AM (in response to matt.lukoff.0)Have you tried this calcuation 
IF ISNULL([ID1]) THEN [ID2]
ELSEIF ISNULL([ID2]) THEN [ID3]
ELSEIF ISNULL([ID3]) THEN NULL
END

2. Re: Help with an if/then formula for a field
David Li Oct 11, 2016 8:51 AM (in response to Shelby Lovejoy)Hi Matt! You can do it Shelby's way, or you can also use the IFNULL() function.
IFNULL([ID1], IFNULL([ID2], [ID3]))

3. Re: Help with an if/then formula for a field
matt.lukoff.0 Oct 11, 2016 8:55 AM (in response to David Li)Shelby Lovejoy and @David LI thank you however both ways seem to be ignoring what I really want by default which is ID1. I only want to use this function if ID1 is Null but otherwise I want to show ID1.

4. Re: Help with an if/then formula for a field
Shelby Lovejoy Oct 11, 2016 9:00 AM (in response to matt.lukoff.0)1 of 1 people found this helpfulWhat about this
IF NOT ISNULL([ID1]) THEN [ID1]
ELSEIF ISNULL( [ID1]) THEN [ID2]
ELSEIF ISNULL([ID2]) THEN [ID3]
ELSEIF ISNULL([ID3]) THEN NULL
END

5. Re: Help with an if/then formula for a field
David Li Oct 11, 2016 9:06 AM (in response to matt.lukoff.0)Did you try to use the calculation? It should work. IFNULL(X, Y) will return X if X is not null. If it is null, it will return Y.

6. Re: Help with an if/then formula for a field
Shelby Lovejoy Oct 11, 2016 9:13 AM (in response to matt.lukoff.0)1 of 1 people found this helpfulYou might want to double check your raw data.
There were times when I expected something to return as NULL but it returned as blank in my data set.
Based on that information, I had to adjust my calculations.
Just a tip!

7. Re: Help with an if/then formula for a field
matt.lukoff.0 Oct 11, 2016 10:08 AM (in response to Shelby Lovejoy)Shelby Lovejoy thanks, adding that If NOT IsNULL worked and the formula is great. @David LI, thank you for your help too.