Hello everybody,
I am a novice about apps and programming and I have very basic knowledge, just to start messing around with an app.
I have started a small app to manage shifts at work and I would need help to solve some things that I don't know how to solve:
1.- I would need to have a column with a formula that adds up the hours worked during the current week and that at the beginning of the following week it will restart and add up the week's entries again.
2.- I would need the same to add the hours you work during the month.
3.- How can I use these results independently to express it in a UX view.
Thanks in advance and best regards.
Solved! Go to Solution.
1. Weekly sum:
2. Monthly Sum:
SUM( SELECT( table[hours],
MONTH([date]) = MONTH(TODAY())
))
To start to help do you want to share with us what columns and tables you have the moment?
1. Weekly sum:
2. Monthly Sum:
SUM( SELECT( table[hours],
MONTH([date]) = MONTH(TODAY())
))
Thanks @Joseph_Seddik , this is good for me.!
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |