Dashpivot formulas can help streamline your templates and forms, saving time and eliminating human error (ensuring that your data is accurate). The formulas follow the same syntax as MS Excel and support most of Excel's inbuilt functions that enable users to leverage data effectively, so if you're already familiar with the formulas in MS Excel, then you'll easily master applying these formulas in Dashpivot.

Formula cells can be used in default tables or prefilled tables by setting the cells as 'Formula' cells.

In default tables, your formulas will reference columns, so each time you add a new row in filling out your form, the same formula applies to each cell in that column. Take note that default tables allow you to add as many rows as you want once you're already filling out your form.

In prefilled tables, formulas reference cells (not columns) and can reference any cell in the table, not just the cells in the same column or row, which means calculations can occur across all rows & columns within the prefilled table. Take note that a prefilled table allows a fixed number of rows when you're creating your template.

Formulas can reference number cells, time cells, date cells, formula cells, and list cells.

The selection/drop down list is located in the drop down when you try to set the type of field your cell is.

Formulas can reference number cells, time cells, date cells, formula cells, and list cells from other tables by including 'Table_Num!' in your formula.

In referencing cells from other tables, you need to specify which table it originates from.

In the example above, the formulas are used:

You can reference multiple tables in one formula, for example: