How to bring dates from multiple columns onto a single column

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

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.

Thank you, it works.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.