I have a table like so...
I would like this result....
Many Thanks all I will accept your solution if correct tomorow morning!
Go to 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])
View solution in original post
@Greg_Deckler Happy days that's perfect thank you very much!
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!