This feature allows you to automatically display a Pass or Fail result at the bottom of a table using a count-based formula. It is commonly used when you want to determine an overall outcome based on how many times a specific value (such as “Fail”) appears in a column. This applies to tables in Dashpivot Web templates and is designed for template editors configuring conditional logic using formulas.
Prerequisites
Before you begin make sure you have the following:
Plan: Standard (or higher)
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot, Basic excel formula skills
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open the template in Dashpivot Web.
Navigate to the table where you want to calculate the overall Pass or Fail result.
Identify the column that contains the responses you want to assess (for example, a List field with “Yes” and “No”).
Add a cell in the table footer (bottom row) where the overall result will appear.
Enter a formula in a cell to count responses and return a Pass or Fail result.
Example 1: Fail if any “Fail” response exists
Use this formula if the result should return Fail when at least one “Fail” appears in the column:
=IF(COUNTIF(B:B, "Fail")>0, "Fail", "Pass")
Example 2: Default table – Pass if 80% or more responses are “Yes”
If it is a Default table with “Yes” answers in the second column, and the condition is to return Pass when at least 80% of questions are answered “Yes”, use the formula below in another table:
=IF(COUNTIF(Table1!B:B, "Yes")>=COUNTA(Table1!A:A)*0.80, "Pass", "Fail")
In this example:
COUNTIF(Table1!B:B, "Yes")counts how many “Yes” responses are in column B.COUNTA(Table1!A:A)counts the total number of completed rows (based on column A).*0.80sets the 80% threshold.
Example 3: Prefilled table – Pass if 80% or more responses are “Yes”
If it is a Prefilled table where the questions are fixed, and the condition is to return Pass when at least 80% of questions are answered “Yes”, enter the following formula in the last row of the column (or another suitable cell in the column):
=IF(COUNTIF(B1:B5, "Yes")>=3, "Pass", "Fail")