# Row Count based on Checkbox condition?

**URL:** <https://community.glideapps.com/t/row-count-based-on-checkbox-condition/26756>\
**Category:** Ask for Help\
**Created:** [May 13, 2021, 2:31pm UTC](https://community.glideapps.com/t/row-count-based-on-checkbox-condition/26756 "2021-05-13T14:31:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shiv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shiv/32/25831_2.png) [@Shiv](https://community.glideapps.com/u/Shiv)\
**Post date:** [May 13, 2021, 2:31pm UTC](https://community.glideapps.com/t/row-count-based-on-checkbox-condition/26756/1 "2021-05-13T14:31:52Z")

</div>

I have a table that has users, posts, and post-visibility ( public or private - which is controlled using a switch - which is basically a checkbox in the data table ). How do I gather the total count of public posts for a given user? Or in simple is there a way of counting the rows for a given user based on a boolean value of a column.

What I am thinking is a series of columns where I convert the checkbox to text (true/false) then filter only true or false based posts and then get a count. Is there a diff or a simpler way to do it?

Thanks

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 13, 2021, 3:08pm UTC](https://community.glideapps.com/t/row-count-based-on-checkbox-condition/26756/2 "2021-05-13T15:08:35Z")

</div>

You can create rollup columns that count rows or unique rows for an entire sheet, or you can point that rollup to a relation which will count the number of rows or unique rows in that particular relation. Sound like you just need to create a relation using a user email, or combine user email and ‘true’ into a template column and use the templates to build your relation.