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.