# Rolling point counter by date **URL:** \ **Category:** Ask for Help\ **Created:** [June 30, 2021, 10:03am UTC](https://community.glideapps.com/t/rolling-point-counter-by-date/28519 "2021-06-30T10:03:25Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Dale\_Nelson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dale_nelson/32/18650_2.png) [@Dale\_Nelson](https://community.glideapps.com/u/Dale_Nelson)\ **Post date:** [June 30, 2021, 10:03am UTC](https://community.glideapps.com/t/rolling-point-counter-by-date/28519/1 "2021-06-30T10:03:25Z")
Hey Team, I was wondering if I could get assistance with this I have a log sheet that records various activities and allocates points and keeps track of the date the activity was logged. I am looking to have a challenge based on a week long period so I only want to count the dates within this period Where I am getting stuck is displaying the points on a day by day inline list for each user. So on date 1 (day 1) only rolling up to sum the points for this date and display it for the day. The the same for date 2 (day 2) Is this something that could be achieved? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [June 30, 2021, 10:19am UTC](https://community.glideapps.com/t/rolling-point-counter-by-date/28519/2 "2021-06-30T10:19:31Z")
What you need to do is create a template column of the two columns you need to “combine” to apply your rollup. Make a template of the user’s email (or other unique identifier) and the date (you may also want to “lock” in the date formatting by first creating a template column that stores the date as text first — this might not be necessary, but it’s still something I do in these cases). Once you’ve got the template column (i.e. [email@email.com](mailto:email@email.com) April 1, 2021), create a multiple relation that check if the template matches itself. Then, create a rollup on this relation to get the sum of all the matches. ---
**Author:** ![Dale\_Nelson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dale_nelson/32/18650_2.png) [@Dale\_Nelson](https://community.glideapps.com/u/Dale_Nelson)\ **Post date:** [June 30, 2021, 11:07pm UTC](https://community.glideapps.com/t/rolling-point-counter-by-date/28519/3 "2021-06-30T23:07:58Z")
> [@kyleheney](#): > > reate a rollup on this relation to get the sum of all the matches. Worked a treat, thank you ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/rolling-point-counter-by-date/28519/4 "2024-01-17T16:51:38Z")