COUNTIF or SUMIF Formula in Report Summaries

Currently the summary count function only supports basic formulas. It would be great to be able to have the ability to use a COUNTIF or SUMIF Formula in report summaries. Specifically to count only the checked boxes. This feature would be nice to roll up metric data quickly and avoid the need to create a separate metric page.

Sign in to vote!

Find more posts tagged with

Formulas

Reports

functionality

Idea Submitted

Comments

Adrian Mandile CHESS

If you include a Checkbox column In a Report, and want to use it for a Summary, it only offers the COUNT summary type and counts ALL the checkboxes regardless of whether they are ticked or not.

However, it would be great if we could also have the SUM summary type made available, which would ADD the checkbox values – i.e. a sum of the "1" values in TICKED checkboxes ONLY.

Sue Hill

Agree need this feature in reporting, counting checkboxes in a column

MariaCurtis

Can you please allow COUNTIF in report summaries? For example, in the below report, in order to get the true count of how many routers we have checked, I have to have a helper column in my sheet that counts when the box is checked. And then I can sum that in reports. It would be better if I didn't need the helper column and could just COUNTIF TRUE directly in the report!

Currently the Count shows 7. If we had COUNTIF TRUE we could get it to say 2 without the need for the helper.

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.