I am trying to update every current value based on the previous value of another property.
Actually, I need to do the task with dates, but just to keep it simple, I'll explain my problem with simple numbers.
I have
Start
, which is1
.Stop
, which is already definedEnd
Duration
, which is already defined
My goal
Start
=Duration
of previous indexEnd
of previous indexEnd
=Start
Stop
of current value
To illustrate, I added the screenshot of the table, how it should look like.
Desired view
Current View
I have forked your sandbox to create a proof-of-concept example: