Summary no longer summarizing

Hello you wonderfully helpful community,

I have a report that is showing me if rows were cancelled or released. When I first set up the report about 5 weeks ago, The summary would show me a count of checked boxes. For instance, 7 cancelled and 32 released. The report now just shows a count of rows regardless of checked status. I have tried changing things around, refreshing and even created a second report and it still will not show me the count of checked boxes like it did for the first several weeks. Has anyone else had this issue and is there anything I can do besides COUNTIF formulas?

Thanks in advance!


  • Garrett Henke
    Garrett Henke ✭✭✭✭✭

    The report is counting all of the checkboxes because checkboxes are boolean values: True or checked =1 and False or unchecked = 0. So no matter checked or unchecked there is a value present. You can create helper columns to look to see if the box is checked and filter the report based on that value

    edited 02/07/22

    I am experiencing this same issue now. I have older reports where summary would only count cells that had been checked; summary was working as intended. Within the last 2 weeks, the summary has started counting all rows, regardless of the cell being checked or unchecked. I did not have to use helper columns in the past. I have submitted a ticket to Smartsheet to resolve the issue.

  • @NMSI INVITATION has your issue been resolved? I'm having the same issue where nearly 100 reports were set up using sum count on checkboxes and worked fine until recently. I don't want to have to create helper columns and update more than 100 reports so have submitted a ticket. Just wondering why Smartsheet is addressing these as on-offs in stead of systemically

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!