Cross Block Formulas

To reference a cell or range from another block by typing out the entire formula, make sure you include the '' and !

='Timetable'!A1

'Timetable' is the block name

A1 is the cell name

Dynamic Grids

In addition to referencing a single cell or a selected range of cells in another block, you can reference an entire row or column programmatically, which gives your data another dimension. This is a powerful tool that helps make your Subsets reusable.

pageBlock ReferencespageRange Formulas

Last updated