This guide explains how to automatically number rows in a Default Table in Dashpivot. Auto-numbering allows you to keep track of the quantity of rowed items as you add more rows to your form. This is useful for item tracking, checklists, and structured records where sequential numbering improves clarity and organisation.
Prerequisites
Before you begin make sure you have the following:
Plan: Standard
Permission: Org Controller or Project Controller or Team Controller
Skills Required: Dashpivot, Excel-type formula
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
Open your template in edit mode.
Navigate to the left sidebar.
Under Table, click Default table to ensure you are using a Default Table.
Go to the column you want to use as the row counter (this is usually the first column).
Hover over the cell and change the field type to Formula.
Enter one of the following formulas to automatically number the rows:
=TEXT(ROW(),"#")
or
=TEXT(ROW(),"0")
Save the template.
As new rows are added when filling out the form, the numbering will automatically increment (1, 2, 3, and so on).
Limitations
Tables cannot be automatically numbered in hierarchical formats such as 1, 1.1, 1.2, 1.3, etc.
As an alternative, you can create separate tables for different numbered sections (for example, Table 1 intended for “1” and Table 2 intended for “2”).