This is something that’s very simple in Excel or Google Sheets (which I am trying to migrate from) but I was not able to Google an obvious solution for Coda.
- Each week is represented by a row.
- I have a column with a certain metric (hours) that changes from week to week.
- I have another column that tracks a WoW delta for that metric (20 hour drop = -20, 5 hour increase = +5 etc)
How can this be accomplished with a formula, so that each cell runs basic math and subtracts value of the cell below from its own value?