Countif on a checkbox
I have a few checkboxes and I want a count of how many have been ticked. Is this possible? If so, what's the formula? thanks
7 replies
-
cnt(select TablewhereTheCheckboxesAre where checkbox = true)
Steven.
-
That works thanks, but how do I total up multiple checkboxes? I have 9 checkboxes. How do i find out how many have been ticked? Ideally I'd like to find the percentage of ticked boxes
-
let tot := cnt(select TablewhereTheChekboxesAre) * 9;
let chked := cnt(select TablewhereTheCheckboxesAre where checkbox1 = true) + cnt(select TablewhereTheCheckboxesAre where checkbox2 = true) + cnt(select TablewhereTheCheckboxesAre where checkbox3 = true) + cnt(select TablewhereTheCheckboxesAre where checkbox4 = true) + cnt(select TablewhereTheCheckboxesAre where checkbox5 = true) + cnt(select TablewhereTheCheckboxesAre where checkbox6 = true) + cnt(select TablewhereTheCheckboxesAre where checkbox7 = true) + cnt(select TablewhereTheCheckboxesAre where checkbox8 = true) + cnt(select TablewhereTheCheckboxesAre where checkbox9 = true);
let percent := (chked/tot) * 100;
percentSteven
-
thanks! that worked - I'm getting close to what I'm trying to achieve. That has counted all the records in the table combined. Each record has the same 9 checkboxes that need to be checked, but I'd like that percentage of ticked checkboxes to be just associated for each record. if that makes sense. thanks Steven you're being very helpful
-
so like in the picture above, i want to know the percentage for each record
-
Hi, maybe this can help :
Steven.
-
Thank you Steven!!! That's exactly what's needed. Very grateful for you help
Content aside
- 3 yrs agoLast active
- 7Replies
- 525Views