Forum Discussion
Ttaylor9870
Helper III
Helper IIIIf null, then use other columns values (Easy IF statement maybe?)
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 resu...
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])
Greg_Deckler
Community Champion
Community ChampionTtaylor9870 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])
Ttaylor9870Helper III
Helper IIIGreg_Deckler Happy days that's perfect thank you very much!