Default tables in Dashpivot Web let you add unlimited rows, but they do not support built-in totals. To count how many times “Yes” or “No” is selected in a default table and display the result, you can use a second table with formulas to calculate and show the totals. This article explains how to set up that cross-referencing.
Video Walkthrough
Prerequisites
Before you begin make sure you have the following:
Plan: FreeTrial, Standard, Pro, Premium, Platinum
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot, basic Excel or Google Sheets formula skills
Device Type: Computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open the form template in edit mode.
Add a Default table to the form as your source table.
Add a column that captures a Yes/No response (using a list with “Yes” and “No” helps reduce errors).
Save the default table.
Add a second table to the form and set it as a Prefilled table — this will be used to display totals.
Select the cell in the prefilled table where the total should appear and change the cell type to Formula.
Enter a
COUNTIFformula that references the default table column. For example:=COUNTIF(Table1!B:B, "Yes")Replace
Table1with your default table’s name, andB:Bwith the column containing the Yes/No values.Table1with the name of your default table.B:Bwith the column that contains the Yes/No values."Yes"with the value you want to count.
(Optional) Add another formula cell to count “No” selections using the same approach, replacing
"Yes"with"No".Save the template.
Test the form by adding multiple rows to the default table, selecting Yes/No values, and confirming the totals update in the prefilled table.
Note
COUNTIFformulas are not case insensitive — “Yes”, “yes”, and “YES” are treated the same.Default tables cannot have totals built into them, so totals must be shown in a separate prefilled table using formulas.
Formula cells must be placed in prefilled tables.