How do I compare a date value of two rows, (named exactly the same) using a formula in the same table?
Hi @Konrad_Mertner,
Can you please describe in more detail what exactly you want to achieve?
It would also be helpful if you could share your document or create a dummy document and share that.
Best regards
Jannis
This is where Coda is completely different to excel.
There are a couple of examples in the community, including one that I made in response to a similar question:
Hopefully that helps.
Hi Jannis,
sharing the document would mean a lot of cleaning up, because it contains a lot of sensitive data. I’ll try to explain in more detail.
I have a table with rows containing a start and end date. The rows are tasks of a project.
A user should be able to adjust the dates in a timeline and be able to give a reason for the delay.
I want to keep the rows to have a history.
When a user adjusts a date, a formula should compare the date to the historic last entry for this task. if it differs, a button should be enabled to add a reason from a select to that row, mark that row as a past entry and create a new one.
I’m gonna check your website out
1 Like
Hi Konrad,
Have you considered using plan versions? Add a new column called “Plan Version”. When a plan is updated, create a new plan version, copy all rows to that, and then change the rows needed.
If the changes are more ad-hoc and you do not want to create full new plan versions, you would need to do what you described, but then it becomes a little bit more tricky because you need to identify, per row, what is the most recent, and the one before that. if you want to make a comparison on a single row.
If you want to show the whole plan, you can use formulas to determine the most recent, or you can use indicators to indicate most recent. And then enforce that.
P