Checkbox Formula

jkrenn000

Hello,

I want to be able to count how many times a checkbox has been selected. I can have the box selected and unselected multiple times when we have to resubmit an application. Any ideas?

=Chris Palmer

Hello @jkrenn000

This formula will count all check boxes that are checked in the column.

=COUNTIFS([Automation Package Submitted]:[Automation Package Submitted], 1)

If you're wanting to specifically count how many times the box is selected and unselected you could possibly do this through an automation workflow, and have the results print on another sheet.