Formula to count the number of checked/toggled boxes

1

image
image789×378 30.7 KB

How do I set up the formula so that I can get the count of number of checked boxes.

2

See if that helps

image
image803×513 18.1 KB

Checked boxes holds values of either true or false.

So, to get a count of checked versus unchecked, I’d use DISPATCH JULY.CountIf(DISPATCH - ACTUAL)

3

hi @VINAY_B_C ,

@Mohammad_Mohammad2 is right, it works as described

an alternative is this one:

[DISPATCH JULY-2022].Filter([On Time]).Count()

image
image1435×1130 40.6 KB

the main advantage of my suggestion is that filters run faster and more efficient than the CountIf(), but both do the job. And since True() is the default value of a checkbox, you can keep it short like this, no need for [On Time]=True() or [On Time].Contains(True())

Cheers, Christiaan

2 Likes
4

Hi Mohammad , thank you for the helping out.

5

Hi Christiaan , thank you for the helping out.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.