This guide explains how to count the number of rows in a Default Table in Dashpivot Web using a formula. Counting rows is useful for tracking the number of entries, inspections, hazards, or checklist items recorded in a form. Using a counting formula ensures totals update automatically as users add new rows.
Prerequisites
Before you begin make sure you have the following:
Plan: Standard, Pro, Premium, or Platinum
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot, Excel formula knowledge
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open your template and navigate to the Default Table where you want to count rows.
Identify the column that will always contain data when a row is completed (for example, a Name, Description, or List field).
Select the cell where you want the total row count to appear. This should be set as a Formula field.
Select the first display cell in the row number column and set it as a Formula field.
Enter one of the following formulas in the display cell:
=TEXT(ROW(),"#")
or
=TEXT(ROW(),"0")
These formulas automatically return the row number as you click the '+' button to add new rows while filling out the form.
Save the template.
As users add new rows to the Default Table, the row number will automatically display for each new entry.
Alternative: Count Rows in a Separate Counter Table
You may want to display the total number of rows from your Default Table (Table 1) in a separate counter table (Table 2).
Create a Prefilled Table to use as the counter display (Table 2).
Select the display cell in Table 2 and set it as a Formula field.
Enter the following formula:
=COUNTA(Table1!A:A)
This formula counts the number of non-empty cells in Column A of Table 1.
As rows are added to Table 1, the counter in Table 2 will automatically update.
Default Tables do not have a fixed number of rows. Any new rows added will be included in the count as long as they contain a value in the referenced column.