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.