Update date column and copy value from a different date column only once

Platform discussions Special workflows & use cases
1

Hi,
Looking for a way to update column date and copy date from a different date column only once.

Not sure if it’s automation (preferably) or formula,
but the scenario is that column date 1 is not necessarily being created with a date value, but when it does being updated with one,
I want to copy it over to the other date column for tracking and comparison purpose (original date vs most recent date).

Hope this was clear enough, thanks in advanced.

2

Same issue here! But also I need to copy date created by a formula, to a regular date column. This is because Start + End = Timeline app does not recognise end time from a formula column. Thanks!

3

Hi @Marcelo_BCN - Have you checked out General Caster? You can use formulas and cast the result to standard columns. There is a free tier depending on your usage.

Thanks
Mark