Hi Seets/GlideTable Gurus - need help with a formula or relation setup
Pls pardon me if it sounds too basic but am not an excel person when it comes to formula spanning across sheets.
I have 2 tables
Users - which has emails
Posts - which has emails, posts, boolean ( which is specific to each post )
Now I want 2 things ( in the Users table )
#1 For each user in the Users sheet, I want the count of total posts in the Posts sheet ( which am able to figure out using relation and count )
#2 I also want the count of posts in the Posts sheet per user which has value as TRUE or FALSE in the boolean column.
Is there a way I can filter down the results I want in #2 using relations or similar?
I am trying to do that in sheets using COUNTIFS but not able to get through.