Cross-referencing allows you to link cells from one table (within your template) to another.
Before setting up the equation, you'll need to ensure you've enabled cross table referencing within the template.
To do this, click onto any formula cell in the form builder. Select 'Enable table cross-referencing' if the button appears (if it doesn't, it means it's already enabled and you're good to go!)
When referencing another table, you'll need to know:
The table number you'd like to reference
The column/cell you'd like to reference
Using this information, you can then reference other tables using this formatting in your formula: Table#!cell_reference
. E.g Table5!D:D or Table3!C1.
Note:
To reference all the values in an entire column, use
A:A
,B:B
, ect. notation from the table in the formula.Default tables can automatically increment the cell ID
=A1+1
, if this is not the desired behaviour, use$A1
within your formula.You can store constants using formula cell
=1
or=”TEXT”
, as a pre-filled text/number cell.