# Conditional count in a different data table

**URL:** <https://community.glideapps.com/t/conditional-count-in-a-different-data-table/50171>\
**Category:** Ask for Help\
**Created:** [September 26, 2022, 3:00am UTC](https://community.glideapps.com/t/conditional-count-in-a-different-data-table/50171 "2022-09-26T03:00:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MortenSchroeder](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@MortenSchroeder](https://community.glideapps.com/u/MortenSchroeder)\
**Post date:** [September 26, 2022, 3:00am UTC](https://community.glideapps.com/t/conditional-count-in-a-different-data-table/50171/1 "2022-09-26T03:00:27Z")

</div>

Hi All,

I’m pretty sure this is a basic question so apologies for my stupid question but simply haven’t been able to find an answer to this. I am trying to figure out how to do a conditional count across two glide datatables. I know how to do it in Google sheet, but I want to do it inside Glide.

So I have two data tables: One with users (each row is a user) and one with reminders added by users (each row is a reminder and is tied to each user via e-mail). In the user data table I wish to add a column that counts how many reminders each user has made in the other data table. How do I do that? In google sheet it could be a countif formula.

THANK YOU

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 26, 2022, 3:06am UTC](https://community.glideapps.com/t/conditional-count-in-a-different-data-table/50171/2 "2022-09-26T03:06:01Z")

</div>

- In your Users table, create a relation column that matches the user email address with the email address in your Reminders table. This must be a [_multiple_](https://www.glideapps.com/docs/reference/computed-columns/relations#multiple-relations) relation.
- Add a [rollup](https://www.glideapps.com/docs/reference/computed-columns/rollup-column) column that takes a count of (any column) through that relation

---

<div class="post-metadata">

**Author:** ![MortenSchroeder](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@MortenSchroeder](https://community.glideapps.com/u/MortenSchroeder)\
**Post date:** [September 26, 2022, 3:17pm UTC](https://community.glideapps.com/t/conditional-count-in-a-different-data-table/50171/3 "2022-09-26T15:17:57Z")

</div>

THANK YOU!! Nailed it

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 27, 2022, 3:18pm UTC](https://community.glideapps.com/t/conditional-count-in-a-different-data-table/50171/4 "2022-09-27T15:18:21Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.