Checkbox Formula

jkrenn000
jkrenn000 ✭✭
in Smartsheet Basics

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?

image.png


· Share on FacebookShare on Twitter

Answers

  • =Chris Palmer
    =Chris Palmer Community Champion
    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/

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video