Count checkboxes in multiple select cell
Hi  is there a formula I can use to count the number of checkboxes in a multiple select cell?
Many thanks.
Best Answers

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

Many thanks!

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")
Answers

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

Many thanks!

No problem mate

@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?

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")

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

Any time and glad to help, @22Wordsmith :)
Help Article Resources
Categories
Check out the Formula Handbook template!