Dashpivot Web allows you to auto-populate dates in a Prefilled table by incrementing from a previous row using a formula. This is useful when logging structured entries where each row should follow a consistent date sequence, such as daily logs, maintenance schedules, or compliance registers. This method requires a reference Date field within the table.
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 in the Template Editor.
Navigate to the left panel and select Prefilled table under Table.
In the first row, set the date cell as a Date field.
In the second row, set the date cell as a Formula field.
=TEXT(A1+Number,"DD/MM/YYYY")
Replace Number with the number of days you want to add to the previous date (for example,
A1+1to add 1 day orA1+7to add 7 days).Click Save to apply your changes.
Notes
This method only works in Prefilled tables because the formula requires a reference date from a previous row.
The
TEXT()function ensures the correct date format is maintained.You can adjust the number added to create daily, weekly, or custom date intervals.
Example
Set the first row of your date cell as a 'Date Field'. Set second row date cell as a 'Formula field' as shown (for example).
