Need solution to formula issue coming from Excel

[Clive_Davies]

Hi, really love Coda, great potential but as a ‘first steps’ test i have brought in a simple spreadsheet I use as a service log.

Each row has a date and several columns for engine hours. These are Actual, Elapsed and Next Due. The Excel sheet uses a formula in each row to reference the previous row so I can calculate the elapsed, and a simple row addition gives me the next Due.

My issue is how do I reference the previous row to get the last Actual?

Thanks for any assistance anyone can give.
Regards.

[Paul_Danyliuk]

Welcome to the community! Take a look here:

Referencing the cell above

Sometimes you need to implement iterative calculation where a value in the next row depends on the value in the previous row (e.g., interest calculator). To do this in Excel / Sheets, you simply reference the cell above by specifying the row as current row index minus 1. In Coda, though, there is no concept of “cell reference” or a ready-to-use row index, and if you try to enter the formula for Value column as =Value.Nth(…), you will get a circular reference error. Solution? — Construct someth…

[Clive_Davies]

Hi @Paul_Danyliuk,

Many thanks, my urgency overcame my ability to search. Its understanding the correct terms/words to use in search. I’ll get better and I am really excited about the potential of Coda product, I will use and recommend.