# Count specific entries from one table to another
**URL:** https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504
**Category:** Ask for Help
**Created:** [October 23, 2020, 11:21am UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504 "2020-10-23T11:21:57Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [October 23, 2020, 11:21am UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/1 "2020-10-23T11:21:57Z")
Hello @Jeff_Hager @Manan_Mehta @ThinhDinh @Robert_Petitto,
I have one table having 50 entries with Name, Type, Status etc. These are user specific columns.
Each such entries are divided in three Status viz. Active, Expired, Expiring Soon.
A particular user has 20 entries out of which 7 are expired, I want this count (7 expired) in User profile table.
I tried but not able to achieve this. I hope you guys already know how to do this.
Thanks in advance.
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [October 23, 2020, 11:24am UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/2 "2020-10-23T11:24:21Z")
I don’t believe you can do rollups on user-specific columns yet.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 23, 2020, 11:24am UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/3 "2020-10-23T11:24:58Z")
Which of those Name, Type, Status are user-specific columns?
---
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [October 23, 2020, 11:26am UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/4 "2020-10-23T11:26:41Z")
User can make user-specific entry and each entry has such status and details.
---
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [October 23, 2020, 11:35am UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/5 "2020-10-23T11:35:28Z")
Just to explain this in details, you can see following Glide Table.
There are 9 entries, out of this, 5 are posted by one user and 4 by another user.
So for one user, out of 4, one entry is Expired and for another user also, one entry is Expired out of Five.
I want this count in User Profile Column in respective User Row that he has " 1 " entry with “Expired” Status.
I hope this helps.
Thanks
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 23, 2020, 11:41am UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/6 "2020-10-23T11:41:31Z")
Create a template of name and status joined together. Use the template to create a relation to that same template (relation to itself). Then create a Rollup count against the relation.
---
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [October 23, 2020, 12:25pm UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/7 "2020-10-23T12:25:35Z")
Thank you @Jeff_Hager for the response. I am sorry but I am stuck somewhere.
I created Template with Name and Status in Main Glide Table. But I am not able to proceed further, I guess I could not understand what your mentioned.
Can you please help what exactly I need to do?
Thanks
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [October 23, 2020, 12:54pm UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/8 "2020-10-23T12:54:29Z")
Hey @Pratik_Shah,
If I understand correctly. Once you have created the template you need to:
1. Create a relation where “that template” matches the same template on the same tab.
2. Have a Rollup against the relation.
---
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [October 23, 2020, 1:19pm UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/9 "2020-10-23T13:19:42Z")
Thank you @SantiagoPerez for response.
I actually want the count in User Profile tab (i.e. another tab) from the User Entries Tab.
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [October 23, 2020, 1:27pm UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/10 "2020-10-23T13:27:29Z")
So you have the user-specific column in a different tab?
I have not idea if this would work but I think you could create an ITE.
If user-specific column is true then “that template”
Then make a relation of that template to the one in you users sheets.
I’m sure @Jeff_Hager has a better idea.
---
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [October 23, 2020, 1:27pm UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/11 "2020-10-23T13:27:57Z")
Thanks, I guess i got it now. Thank you for all your help @Jeff_Hager @ThinhDinh @SantiagoPerez
---
### Author:  [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [October 23, 2020, 1:36pm UTC](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/12 "2020-10-23T13:36:41Z")
I now understood what he wanted to tell here.
> [@Count specific entries from one table to another](https://community.glideapps.com/t/count-specific-entries-from-one-table-to-another/17504/6):
>
> Create a template of name and status joined together. Use the template to create a relation to that same template (relation to itself). Then create a Rollup count against the relation.
I created Template with Name and Existing Status in Main Tab and created another Template with Name (User) and expected Status in User profile Tab, then created relation column with later template to the Former Template and then Rollup.
This worked what I wanted to achieve.