Problem solved with $1 = remote(A,@@#$1)
as described on the manual page https://orgmode.org/manual/References.html#Field-coordinates-in-formulas-1 <https://orgmode.org/manual/References.html#Field-coordinates-in-formulas-1> Where is the coordinate @@# documented? > On 11 Mar 2024, at 18:52, Wu Ming <wu.mi...@icloud.com> wrote: > > Hello, > > #+NAME: A > Table with header row here > > #+NAME: B > Table with header row here > #+TBLFML: $1 = remote(A,$1) > > Does nothing. > > $1 = remote(A,@0) referring current row w implicit column does not work. > Debug shows on row 2 of current table it returns the value of row 1, the > header, on table A. > > Same result as above with @0$1 instead. > > $1 = remote(A,@2$1) does what expected. For every row copies the same value > of @2$1 from table A to table B. > > Need to refer multiple columns on different tables in a column formula for a > final table. > > Please advise. Thanks. > >
