If null, then use other columns values (Easy IF statement maybe?)

[Ttaylor9870]

Hi All,

I have a table like so...

Order Date	Date Secured
11/11/2022	null
12/11/2022	null
null	14/11/2022
null	15/11/2022
13/11/2022	null

I would like this result....

Order Date	Date Secured	Close Date
11/11/2022	null	11/11/2022
12/11/2022	null	12/11/2022
null	14/11/2022	14/11/2022
null	15/11/2022	15/11/2022
13/11/2022	null	13/11/2022

Many Thanks all I will accept your solution if correct tomorow morning!

Taylor

[Greg_Deckler · Accepted solution]

@Ttaylor9870 So if it is really "null" as in the word "null" it would be:

Close Date Column = IF([Order Date] = "null",[Date Secured],[Order Date])

if the "null" in your data represents a "blank" the it is:

Close Date Column = IF([Order Date] = BLANK(),[Date Secured],[Order Date])

[Ttaylor9870]

@Greg_Deckler Happy days that's perfect thank you very much!