Sign in to submit new ideas and vote
Get Started
We are aware that the yellow status bar is not showing for Ideas, even when logged in.

This has been reported to the website support team and we are looking into it. In the meantime, please add your votes from the list view or by commenting on that idea.

You can see Statuses by filtering the main list.

COUNTIF or SUMIF Formula in Report Summaries

Options

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.

ReportFormula.jpg


5
5 votes

Idea Submitted ยท Last Updated

Comments

  • Adrian Mandile CHESS
    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.

    Adrian Mandile
    CHESS Consulting Australia - Smartsheet Solution Provider Gold Partner
    Collaborative | Holistic | Effective | Systems | Solutions

  • Sue Hill
    Sue Hill โœญโœญโœญโœญ

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

  • MariaCurtis
    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.

    image.png