Conditional count in a different data table

Ask for Help
1

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

2
  • 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 relation.
  • Add a rollup column that takes a count of (any column) through that relation
1 Like
3

THANK YOU!! Nailed it

4

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