Count checkboxes in multiple select cell

22Wordsmith

Hi - is there a formula I can use to count the number of checkboxes in a multiple select cell?

Many thanks.

Ric T

Hi @22Wordsmith,

Smartsheet has a cool formula for this, COUNTM https://help.smartsheet.com/function/countm

For example if you want to count all the number of checkboxes in your column "Potential Impediments", the formula would be:

=COUNTM([Potential Impediments]:[Potential Impediments])

Cheers,

Ric

22Wordsmith

Many thanks!

Ric T

Hi @22Wordsmith, you're absolutely right. If counting "Time to deliver" in your multiselect, it'll look like:

=COUNTIF([Potential Impediments]:[Potential Impediments], "Time to deliver")

Ric T

Hi @22Wordsmith,

Smartsheet has a cool formula for this, COUNTM https://help.smartsheet.com/function/countm

For example if you want to count all the number of checkboxes in your column "Potential Impediments", the formula would be:

=COUNTM([Potential Impediments]:[Potential Impediments])

Cheers,

Ric

22Wordsmith

Many thanks!

Ric T

No problem mate

22Wordsmith

@Ric T Same content but a different count required. How do I count how many times a particular checkbox is marked in the column, please? Would it be a simple COUNTIF?

Ric T

Hi @22Wordsmith, you're absolutely right. If counting "Time to deliver" in your multiselect, it'll look like:

=COUNTIF([Potential Impediments]:[Potential Impediments], "Time to deliver")

22Wordsmith

Many thanks. I had tried so many options the obvious solution eluded me. I appreciate the confirmation.

Ric T

Any time and glad to help, @22Wordsmith :)