Hello! In our table we have multiple checkbox fields that we would like to count/sum if they are checked (in a Total formula field). In our base, there are about five fields that can be checked to indicate that a participant received that credential (it is unchecked if they did not).
What’s the formula we can use to count/sum the checked boxes across these five fields for the Total field?
Create a Formula-type field with this formula:
LEN(CONCATENATE({Field 1},{Field 2},{Field 3},{Field 4},{Field 5}))/4
^ The formula is combining all the values of the fields into one long string. If a Checkbox-type field is checked, its value is true. So you want the length of the combined string divided by 4.
Or just use COUNTALL()
COUNTALL({Field 1},{Field 2},{Field 3},{Field 4},{Field 5})
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.