Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dates

scenario: there is start, due and due revised dates columns However, the due revised column has empty cells.   Question: how to configure due revised and due date columns as one with keeping data...
tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi Anonymous,

 

I would suggest to create a new column with an if logic according to your needs, Maybe something like this?

TomsNewColumn =
IF ( Table[Due Date revised] = blank(), Table[Due Date], Table[Due Date revised] )

 

Let me know if this helps! 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/