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