Set date based on date from row above?

[Piet_Strydom]

Hi Max,

Welcome to Coda! And the fact that you do not speak code to good, is an advantage… Coda’s a no-code tool

This is actually not a simple question, as you point out the row sequence can change. Please have a look at @joost_mineur comments on this previous question:

Formulas referencing different rows in the same column

Hello Piet, I understand that people ask for these type of solutions, but they are really tricky. When I started working with coda I tried lots of work-arounds to overcome the lack of row-references. These workaround were very useful in getting to know Coda, but now, some 2 years later, I hardly ever need solutions like that. That said, these methods are very error prone. When rows get added in the middle of the table, or deleted, this type of logic will fail. The formulas can be adjusted to f…

You are going about it the right way, building a new sequence as Joost suggests.
(I have unfortunately not had time to finish the changes that I need to make to my example, so there is no live example at the moment.)

And your formula would like to look something like the below:
(Replace my RowID column, witht he name of your column that contains the sequence number.

Regards
Piet