How to bring dates from multiple columns onto a single column

1

Hello Coda Community, I’m having trouble importing dates from multiple ccolumns onto a single column. I have attached a sample doc for your reference hope it helps .

Link: https://coda.io/d/_dwBH7aESKuX/Importing-dates-from-multiple-coulmns-on-to-a-single-column_su6cRsTN

2

You’ll just need to add a formula to the [Due Date] column

SwitchIf(
  [Wo due date].isNotBlank(), [Wo due date]
  [Project due date].isNotBlank(), [Project due date],
  [Unplanned due date].isNotBlank(), [Unplanned due date]
)

This formula checks to see if the column value is not empty, and then uses that value. It stops when it finds the first “true” case. So the order matters.

3

Thank you, it works.