Request: Report summaries should count checked = 1 and unchecked = 0 for Checkbox columns

CMathews
CMathews ✭✭
edited 05/10/23 in Formulas and Functions

Love the reporting column summaries feature for most column types. However, the Count summary option isn't very useful for Checkbox fields. I want to see how many "violations" there are which we denote with flags being checked or unchecked. I'd expect the following scenario to return "3" and not "5".

Or am I missing a way to configure this to make it return the number of checked flags?


Tags:

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @CMathews

    Add a filter to your report where Flag column 'is checked'. This will only count the flagged flags. If you want a count of both, don't add the filter but add a grouping on the Flag column. You will then see the total of unchecked and checked.

    or, with the Group on the Flag column, sorted Descending Order

    Will this work for you?

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!