Row Count based on Checkbox condition?

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

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.

3 Likes