Ref(#a)

Generates a "reference" to a cell, a, or a region, #a. If a cell has formula #a, it would take the value the table of #a. In contrast, if a cell has formula Ref(#a), its value is a single cell that "points" to the region #a. This value is currently displayed as a string comprised of the UUID for the cell or region and the absolute coordinates of its top left and bottom right corners.

Deref(#a)

Dereference a reference to a cell or table, i.e. replace each cell that contains a reference with the value of the region it is pointed at. In the example below you can see that DeRef(#c) results in a region containing the values of a, #a and #b.

CellwiseRef(#a)

Generates a table of the same dimensions as #a, where each cell is a reference to the corresponding cell in #a.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/ab395aee-3c3d-45c1-9072-d5c09a97cd34/Screenshot_2021-07-13_at_16.51.53.png