Default tables allow users to add unlimited rows but do not support automatic totals. To count how many times “Yes” or “No” is selected in a default table, you can use a second table with formulas to calculate and display the totals. This article explains how to set up that cross-referencing.
Video Walkthrough
Prerequisites
Before you begin make sure you have the following:
Dashpivot
Permission to edit forms or templates
Skills Required:
Dashpivot
Basic Excel or Google Sheets formula skills
Step-by-Step Instructions
Create the source default table
Open the form template in edit mode.
Add a Default table to the form.
Add a column that captures a Yes/No response.
This can be a list field or text field.
Using a list field with “Yes” and “No” reduces data entry errors.
Save the table.
Create the summary table
Add a second table to the form.
Set this table as a Prefilled table.
This table will be used to display totals from the default table.
Add a formula field for the total
Select the cell in the prefilled table where the total should appear.
Change the cell type to Formula.
Enter the COUNTIF formula
In the formula field, enter a COUNTIF formula that references the default table column.
Example:
=COUNTIF(Table1!B:B,"Yes")
Replace:
Table1with the name of your default table.A:Awith the column that contains the Yes/No values."Yes"with the value you want to count.
Count additional values (optional)
To count “No” values, add another formula cell in the prefilled table.
Enter the same formula, replacing
"Yes"with"No".
Example:
=COUNTIF(Table1!B:B,"No")
Test the form
Save the template.
Open the form and add multiple rows to the default table.
Select Yes and No values.
Confirm the totals update correctly in the prefilled table.
Rules
COUNTIFformulas are not case sensitive.Default tables do not support built-in totals.
Totals must be displayed in a separate table using formulas.
Formula cells must be placed in prefilled tables.