Change in Report Summary Function
Was there a recent change to the summaries function in a report. In my example below the summary count would only calculate if the box was checked.
For example the adj approved count for this section would be 1 and the count for adj rejected would be 4, instead of it counting the total rows for both. Is there a way to change this back. I was reading about the countif function but not sure how to apply to all of the sheets that we pull from.
Best Answer
-
Hi @NikiG
It's been confirmed that the COUNT behaviour on a checkbox column in a Report is currently functioning as it should: it will count all rows that contain a checkbox (unchecked or checked) as a number. You will need to Group by if it's checked or not to see the separate numbers, or use a Filter in your Report. An alternative would be to use a COUNTIF cross sheet formula to gather your numbers instead.
I've submitted an Enhancement Request on your behalf so a COUNTIF statement for checkbox columns in Reports can be considered for future developments.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @NikiG
What you're seeing now is the expected behaviour for a COUNT on Symbol or Checkbox columns in Reports.
If you need to see individual Counts (un-checked versus checked) then you can set up a second Grouping in order to split out the two values:
This was a fix our Product team recently released as previously the grouping of un-checked values would have said 0, which is incorrect.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi @NikiG
Just a quick note to let you know that I've let the Product team know about your use-case and how this update has affected your current set-up.
They're currently investigating what the expected behaviour for a Report should be when it comes to checkbox columns and summarizing. I'll post again once there's another update on this, although I don't have an ETA for when this may be.
Thanks,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. is there any update on this issue?
-
Hi @NikiG
It's been confirmed that the COUNT behaviour on a checkbox column in a Report is currently functioning as it should: it will count all rows that contain a checkbox (unchecked or checked) as a number. You will need to Group by if it's checked or not to see the separate numbers, or use a Filter in your Report. An alternative would be to use a COUNTIF cross sheet formula to gather your numbers instead.
I've submitted an Enhancement Request on your behalf so a COUNTIF statement for checkbox columns in Reports can be considered for future developments.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
While I understand why the change was made to how the COUNT summary behavior works on checkboxes, it seems like we should have the option to use a SUM function rather than a COUNT to calculate the number of "true" checked values (1) rather than counting all rows. This would be less effort than developing a new COUNTIF function and would make reporting much more efficient.
I currently have to either change my checkbox columns to a text column and use 1 and 0 values, which doesn't make sense to my end users, or I have to add a helper column that converts checkboxes to a text column across all sheets. Many of my sheets are too close to the cell limit to allow for the addition of another helper column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!