I'm trying to refer to the row number of a remote table, using the current column number shifted by one.
Remote Table: #+NAME: my-table | Header1 | Header2 |
|---------+---------| | a | 23 | | b | 7 | | c | 13 | | d | 66 | | e | 5 | |---------+---------| | Result | 42 |
Table where remote value should be inserted:
...
#+TBLFM: @address@hidden remote(my-table,@$#$2)
My problem is, that this remote reference starts in row 3 (because of @$#), however, I'd like to start in row 2 (that means @$#-1). However, this relative reference does not seem to work here.