When using default tables in Dashpivot, the number of rows isn’t fixed — users add rows as they complete the form. You can automatically count how many rows have been added by using a formula. This lets you display the total number of entries in a separate prefilled table cell.
Prerequisites
Before you begin make sure you have the following:
Plan: All Plan Types
Permission: Home Folder (Template Library) – Org Controller (or higher); Team Folder – Project Controller (or higher)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
In the Template Editor, select Default table from the left panel under Table.
Design your data table as required for your form.
Select Prefilled table from the left panel under Table.
Designate a cell in the prefilled table as your display cell.
Change the display cell to a Formula field.
Enter the following formula in the display cell:
=COUNTA(Source_Table!Column:Column)
Replace
Source_Tablewith the name of your default table.Replace
Columnwith a column that is guaranteed to contain a value in every row.
Example:
If your default table is named Table1 and you want to count entries using Column A, enter:
=COUNTA(Table1!A:A)
This will automatically display the total number of rows added to the default table.