Cross Block Formulas
Last updated
Last updated
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.