Generating a text (Pass/Fail) for a default based on a majority count means that if the number of conditions are met, it will generate your desired text (Pass/Fail). Default tables allow you to continuously add rows when you fill out the form, therefore there isn't a fixed number of rows when the template is created. It is not possible to add the display cell at the bottom of the default table. Therefore, in this case, we'll be using a prefilled table to display the text.
To start, navigate your cursor to the left tab and choose 'Default table' under 'Table' for your data set. Set your number of columns.
Next, navigate your cursor to the left tab and choose 'Prefilled table' under 'Table' for your display cell. Use the formula IF() to your display cell:
=IF(COUNTIF(Source_Table!Column:Column, Criteria)>Number), Condition_Text, Otherwise_Text)
where:
Source_Table - is the default table
Column - the column where you're going to count the number of instances
Number - the condition number of counts
Condition_Text - the text that shows if the statement is true
Otherwise_Text - the text that shows if the statement is false
For example:
Given that there are a Number of employees who took the safety training. The passing score is 80%. You require at least 70% of them to pass the training.
Table 1 - Default table/Data:
Employee_n | (Score) | (Pass/Fail) |
Table 2 - Prefilled table/Overall Result:
Overall Results: | Display Cell (Overall Pass/Overall Fail) |
|
Given that a default table doesn't have a fixed number of rows, populate the text "Overall Pass" in the display cell using the formula in the display cell (Table 2 cell B1) :
=IF(COUNTIF(Table1!C:C, "Pass")>=COUNTA(Table1!C:C)*0.70, "Overall Pass", "Overall Fail")
NOTE: The display cell has a default display of "false" as there are no selections yet.
We're using a COUNTA() formula for the 'Number' as we don't have a fixed number of rows and multiplying it to 70% as the requirement is that 70% of them should pass to consider it as an Overall Pass.