Checkbox Formula

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?


Answers

  • =Chris Palmer
    =Chris Palmer ✭✭✭✭✭
    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.

    https://www.linkedin.com/in/zchrispalmer/