Using formulas to count checkboxes

Platform discussions
1

I’m stumped on something that’s likely very simply.

I’m needing to count the number of checkboxes present on a pulse. What formula can I use for this? Example photo shows an instance where we would want the QA score to show as 4.
Customer Care Agent Feedback + KPI's (3)

2

Hey Erin,

Try this formula:

IF(AND({Checkbox}>0,{Checkbox 1}>0, {Checkbox 2}>0, {Checkbox 3}>0), 4, 0)

If you’d instead like for the output to show the number of boxes checked, you can use this:

IF({Checkbox}>0, 1, 0) + IF({Checkbox 1}>0, 1, 0) + IF({Checkbox 2}>0, 1, 0) + IF({Checkbox 3}>0, 1, 0)

As a final alternative, you can also display the output as a fraction of the total amount:

(IF({Checkbox}>0, 1, 0) + IF({Checkbox 1}>0, 1, 0) + IF({Checkbox 2}>0, 1, 0) + IF({Checkbox 3}>0, 1, 0)) & "/4"

I hope this helps - let me know if you run into any issues :pray:

1 Like
3

I had actually resolved this already, but seeing that there are multiple ways to make this works is super helpful for future instances. Thank you!

1 Like
4

Glad to hear you got this sorted! No problem :slight_smile:

5

Is there a similar formula that could be used for counting number of checked boxes in a column, rather than a row?

I would love to have check boxes with subitems and have a column for the regular item that has a count of the number of subitems that have been checked.

6

Unfortunately, formulas can’t calculate vertically, only horizontally, like a row. Likewise, you can’t create a formula that includes the column summary (yet!).