I have a roadmap table that includes ‘releases’ and launch dates. Every monday we look at the releases where the launch date has changed and we want to be able to look at what the previous date was.
So, i’ve added a column “Previous Launch Date” so that I can see this on a weekly basis. However after sending out the weekly report, i’m trying to add a button that will update the “Previous Launch Date” for all releases with whatever value is in the “Launch Date” so that if if changes again, we can tell what the previous date was (we don’t really need to track changes historically so we’re ok overwriting this one column).
I’m pretty new to coda, so far I have this:
ModifyRows(Releases,Releases.[Previous Launch Date],Releases.[Public Launch Date])
However, this takes ALL the public launch dates and puts all of them into every single row of the previous launch date. Any ideas?