Report Summarize

Eenmeier ✭✭
edited 02/19/24 in Smartsheet Basics


I have a report that I am struggling to summarize correctly. The first is a Drop Down column with options 1-3, the next is a checkbox column. I have grouped the report by the Drop Down column and that is working well, but there does not seem to be a way to count the the checked rows in the checkbox column. I would expect that it would recognize the box checked as "1" and the box not checked as "0", but it does not and is counting all the boxes blank or checked. How can I get a count of the Install Tier grouped and summarized, with a count of the Router with checked boxes on the same report?

Best Answers