How to Calculate the Delta of a Data Set

[Nick_HE]

Ah yes, you’ve stumbled across an area where spreadsheets are a bit more intuitive than Coda’s database table model. (Mainly because Coda is designed for flexibility, letting you create different views of a table in which some of the rows are filtered out, reordered, etc).

What you’re looking for is definitely doable, just takes a bit more legwork.

Have a look at this post:

Date for new row from last of other column

So I have 2 columns. End date and Start date. I am trying to make it that Start date will have the “value for new row” done by taking the date from the last row of End date and add it a day (+1). Both columns are Date type. I tryed several formulas such as Last(), totext() and ect. but always came up with the same result, it automatically fill it with the date of 1/1/1970. Any ideas what is it that im doing worng? [Captura date] Thanks for the help!