Checkbox Formula


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?


  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    edited 02/06/24

    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.