# Can I get a SUM of all user data in User-Specific Column?
**URL:** https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294
**Category:** Ask for Help
**Created:** [February 9, 2022, 8:54am UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294 "2022-02-09T08:54:23Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@free3moose](https://community.glideapps.com/u/free3moose)
#### Post date: [February 9, 2022, 8:54am UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/1 "2022-02-09T08:54:23Z")
I would like to have an “idea” scoring system. Users score an “idea” and the data is stored in a User-Specific Column with that “idea”.
I am aiming to save the score given by the User individually, so they can see the score they provided when returning at a later time. This I understand how to do.
However, I don’t understand how I can SUM all the scores each User provided into a total score. Is there a way to SUM all of the data for the User-Specific column of a row in a datasheet?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 9, 2022, 8:56am UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/2 "2022-02-09T08:56:17Z")
You can only access data of a single signed-in user at a time. You can’t sum different users’ scores if you’re using user-specific columns.
---
### Author:  [@free3moose](https://community.glideapps.com/u/free3moose)
#### Post date: [February 9, 2022, 8:57am UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/3 "2022-02-09T08:57:58Z")
Ok, thanks - I suspected that but wanted to be certain I wasn’t missing something.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 9, 2022, 9:43am UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/4 "2022-02-09T09:43:27Z")
An alternative is have a form to submit their scoring to a new table, but that will consume your row count.
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [February 9, 2022, 10:42am UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/5 "2022-02-09T10:42:47Z")
You can add a button with custom action - where you can use the ADD ROW action to save their score to another sheet to do the sum.
---
### Author:  [@free3moose](https://community.glideapps.com/u/free3moose)
#### Post date: [February 9, 2022, 12:34pm UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/6 "2022-02-09T12:34:07Z")
Thanks @Hassan_Nadeem I have structured my solution like this though I am not finished exploring what is possible.
To get the SUM I’ve created a rollup in my Ideas table with a formula to SUM entries in the Scores table. This provides a total score for each Idea.
I haven’t tried to do the same by User in a User table because I would have to filter results by the Idea and the User. I assume I would rollup these two fields (the Idea field and User email field). However, after that I am not sure if I can filter the results for each Idea and by User. What should my approach here be?
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [February 9, 2022, 1:11pm UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/7 "2022-02-09T13:11:48Z")
@free3moose Lets do a zoom meeting so you can show me the app on backend and I can guide you accordingly.
---
### Author:  [@free3moose](https://community.glideapps.com/u/free3moose)
#### Post date: [February 9, 2022, 3:41pm UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/8 "2022-02-09T15:41:40Z")
Hi @Hassan_Nadeem very kind of you to offer.
I’ve decided to switch out for a different platform because I don’t think Glide is the right way forward for me.
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [February 9, 2022, 3:49pm UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/9 "2022-02-09T15:49:38Z")
@free3moose Can you please share your app idea and the problem you are facing in private chat?
Glide is one of the best no-code platforms and it is the easiest to learn. Would suggest you to stay with it and elaborate on your problem in detail. I am sure you will find a solution.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [February 10, 2022, 3:50pm UTC](https://community.glideapps.com/t/can-i-get-a-sum-of-all-user-data-in-user-specific-column/38294/10 "2022-02-10T15:50:33Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.