How to get `Nth` to return `Blank` if index is not found

[BODHI_SCHNEIDER]

You might want to look at this topic:

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…

Although it solves your problem, the rowid is not reliable in the situatuion, so you might have to tinker around with the formula.

If you have any other questions, you can ask them to me.