You can calculate the percentage of fields completed in a default table and display the result in a summary (prefilled) table using a formula field. This is useful for tracking completion rates, monitoring progress, and ensuring required information is being captured within your forms.
Prerequisites
Before you begin make sure you have the following:
Plan: All Plan Types
Permission: Home Folder (Template Library) – Org Controller (or higher); Team Folder – Project Controller (or higher)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
For a Prefilled Data Table (Known Total Rows)
Add or locate your Prefilled data table (Source_Table).
Add a Prefilled display table and set a display cell as a Formula field.
Enter the following formula in the display cell:
=COUNTIF(Source_Table!Column:Column, Criteria)/Number*100
Replace:
Source_Tablewith your prefilled data table name.Columnwith the column you want to evaluate.Criteriawith the condition that must be met.Numberwith the total number of rows in the table.
Alternatively, if the total number of rows is unknown, use:
=COUNTIF(Source_Table!Column:Column,Criteria)/COUNTA(Source_Table!Column:Column)*100
Example (Prefilled Table)
If you want to calculate the percentage of employees working 8 or more hours and:
Table1is your data tableColumn F contains Hours Worked
Enter:
=COUNTIF(Table1!F:F, ">=8")/COUNTA(Table1!A:A)*100
For a Default Data Table (Unknown Total Rows)
Add or locate your Default table (Source_Table).
Add a Prefilled display table and set a display cell as a Formula field.
Enter the following formula:
=COUNTIF(Source_Table!Column:Column,Criteria)/COUNTA(Source_Table!Column:Column)*100
Replace:
Source_Table → your default table name
Column → the column you want to evaluate
Criteria → the condition that must be met
Since default tables do not have a fixed number of rows, COUNTA() is used to count the total number of rows dynamically.