# Monthly Tasks **URL:** \ **Category:** Ask for Help\ **Created:** [May 13, 2021, 7:36pm UTC](https://community.glideapps.com/t/monthly-tasks/26767 "2021-05-13T19:36:46Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Tombaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tombaker/32/25878_2.png) [@Tombaker](https://community.glideapps.com/u/Tombaker)\ **Post date:** [May 13, 2021, 7:36pm UTC](https://community.glideapps.com/t/monthly-tasks/26767/1 "2021-05-13T19:36:46Z")
Hi I am building an app based on Glide tables so can’t use any kind of Google formula that can’t be done in glide tables. I am working on a volunteer app where a user “commits” to a set number of voluntary work hours per month which I have set up as a number in my user table. As the user logs tasks, they will log the number of hours it took them to the nearest 30 minutes, however I’d like to show a dash board where the user can see progress bar of how many hours they have done against their monthly target. But I need to find a way of logging tasks against a month so when on the 1st it resets the hours done and the hours required to target. I hope that makes more sense to you then it does to me 🤣 ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 13, 2021, 8:02pm UTC](https://community.glideapps.com/t/monthly-tasks/26767/2 "2021-05-13T20:02:40Z")
Hey @Tombaker You’ll have to use some math columns to sum the hours, take the month’s number and so on… Take a look in this topic, and see what you can take from it > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684): > > I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te… ---
**Author:** ![Tombaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tombaker/32/25878_2.png) [@Tombaker](https://community.glideapps.com/u/Tombaker)\ **Post date:** [May 13, 2021, 8:30pm UTC](https://community.glideapps.com/t/monthly-tasks/26767/3 "2021-05-13T20:30:59Z")
@Lucas_Pires thanks I’ll have a look! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 13, 2021, 8:38pm UTC](https://community.glideapps.com/t/monthly-tasks/26767/4 "2021-05-13T20:38:16Z")
One way to do it is to generate a “month code” that uses a math column to combine the year and month values of the log timestamp. Something like year(timestamp)\*100+month(timestamp). This will give you a unique value that you can use for relations and rollups. ---
**Author:** ![Tombaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tombaker/32/25878_2.png) [@Tombaker](https://community.glideapps.com/u/Tombaker)\ **Post date:** [May 13, 2021, 9:32pm UTC](https://community.glideapps.com/t/monthly-tasks/26767/5 "2021-05-13T21:32:19Z")
Thanks @Robert_Petitto, I’ll give that a try! Love the youtube videos by the way! 😀 ---
**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:** [May 14, 2021, 12:57am UTC](https://community.glideapps.com/t/monthly-tasks/26767/6 "2021-05-14T00:57:06Z")
Similar to Bob’s suggestion, you might find this useful… > [@Today date without user login](https://community.glideapps.com/t/today-date-without-user-login/26650/3): > > @Jeff_Hager I just had an epiphany! In my apps, I have lots of columns that look like this: As I was creating yet another one of these yesterday I was thinking to myself “there must be an easier way”. And then it hit me just now as I was reading your post… Challenge: Extract the short month name from a date (eg. “Jan”) The way I normally do this is by first extracting the Month and Day components using date math, and then that stupid if-then-else co… ---
**Author:** ![Tombaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tombaker/32/25878_2.png) [@Tombaker](https://community.glideapps.com/u/Tombaker)\ **Post date:** [May 14, 2021, 7:55am UTC](https://community.glideapps.com/t/monthly-tasks/26767/7 "2021-05-14T07:55:26Z")
Thanks for this really helpful! I’ve found a way to make it work (I think) I have a math column called “current month” with month(now) and a “current year” with year(now) and then I use a template to combine the 2 values. I do this both on the task sheet and the dashboard sheet then use a relation to look up tasks for this month. I am using row owners on both sheets so am I correct in thinking it shouldn’t pick up any tasks not for the current user, or should I combine the user email into the templated “month code”? ---
**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:** [May 14, 2021, 8:03am UTC](https://community.glideapps.com/t/monthly-tasks/26767/8 "2021-05-14T08:03:31Z")
> [@Tombaker](#): > > I have a math column called “current month” with month(now) and a “current year” with year(now) and then I use a template to combine the 2 values. I do this both on the task sheet and the dashboard sheet then use a relation to look up tasks for this month. yep, that should work. > [@Tombaker](#): > > I am using row owners on both sheets so am I correct in thinking it shouldn’t pick up any tasks not for the current user, or should I combine the user email into the templated “month code”? yes, with Row Owners enabled it should sort itself out and each user will only see tasks for those rows that they “own”