Referencing Table and Spreadsheet Cells in Lt

The cells inside a Table, Table Question, Spreadsheet, and Spreadsheet Question panel can be referenced from outside of the panel using a simple formula.
You can reference between any combination of these different panels, and they don't need to be on the same page.

Referencing using the panel name

Tables and Spreadsheets have automatically generated panel names, which are found in the panel footer while editing the panel.

Authors can use these names to reference cells from other panels. This is similar to the way Excel references between sheets.
Simply type =, then the Sheet or Panel name you wish to use, then type !, then the cell reference value.

An example of this would be "=Sheet4!A1" or "=Table1!B2".