Multiple ISNull()

[dlopez]

Simple formula that's killing me, I need a new date column that pulls in values from three date columns when one is null, date order matters so I'll put them in order below

New Date Column	Date 1	Date 2	Date 3
01/05/2018	01/05/2018
05/16/2017		05/16/2017
05/09/2017	05/09/2017
11/21/2018			11/21/2018

My thought was something like 

New Date Column = 

IF ISNull(Date 1)

THEN (Date 2) 

ELSEIF ISNull(Date2)

THEN (Date 3) 

else (Date 1)

endif

I know I messing that up a bit but any help would be greatly appreciated. 

Cheers!

[JosephSerpis · Accepted solution]

Hi @dlopez I came up with an alternative approach let me know what you think? I also amended your code to work for the provided example.

[dlopez]

@JosephSerpis 

Worked like a charm, thanks Joseph!

Cheers, 

david

[christine_assaad]

Hello @dlopez 

You can achieve your goal in many ways:

Formula:

Transpose - Filter and Join for more robust solution in case you have more than 3 fields