If Null Then [Date] Statement

Hi coda community!

Not sure if anyone has any pointers-- I’ve been struggling on writing a sort of If/Then statement in coda.

Essentially I have two different columns containing a date. If the first date column is empty I want to return the date of the second column, otherwise I want the date from the first column in the new “combined date” column I created.

I’d normally go about it by doing something like this:
If [column 1 date] is null then [column 2 date] else [column 1 date] end as combined_date.


Figured it out!

Including the solution in case anyone has a similar question/issue in the future.

If(IsBlank(thisRow.[column2 date]),thisRow.[column1 date],thisRow.[column2 date])