topic Re: How to copy paste a formula column between two different tables in Discussions

How to copy paste a formula column between two different tables

FN — Tue, 23 Apr 2024 15:50:43 GMT

I have two tables coming from two similar files that vary in number of rows.

They share column names and I want to copy-paste formula columns from the old one to the new one.

There is no index I can use to join them.

How can I do that, ideally without JSL?

Re: How to copy paste a formula column between two different tables

jthi — Tue, 23 Apr 2024 15:54:34 GMT

Copy Columns on first table (right click on column header and select Copy Columns) and Paste Columns on second table should work (right click somewhere on column header and select Paste Columns).

Re: How to copy paste a formula column between two different tables

FN — Tue, 23 Apr 2024 16:01:36 GMT

Thanks. It didn't seem to work using the Edit menu. Clicking on the headers was the trick.

Re: How to copy paste a formula column between two different tables

Dantz260 — Fri, 16 Jan 2026 12:13:17 GMT

Can this be scripted? the Equivalent of Selecting the column header, then Ctrl+C, selecting the other header and Ctrl+V?

Re: How to copy paste a formula column between two different tables

jthi — Fri, 16 Jan 2026 12:17:08 GMT

Most likely yes but the method might be slightly different from copy+paste in the script.