Forum Discussion
gilmore_staci
3 years agoHelper II
Count how many checkboxes checked per case
I have 3 checkboxes per case Response missed Restore missed Resolve missed I want to know how many may be checked per case. 0, 1, 2 or all 3 may be checked on any case
gilmore_staci
3 years agoHelper II
Anonymous
I followed your instructions, but mine isn't quite working like yours did, here's a screen shot. I would expect the highlighted count to be 2
Anonymous
3 years agoNot applicable
Hi gilmore_staci ,
Do you want to count columns? My method above is counting rows.
Is it because in the highlight, the values of the two columns are True, so 2 is returned?
If so, you could try adding custom columns to determine True and then return 1. And then sum them up.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.