Skip to content
Gallery
Coda use case support needed
Use cases
More
Share
Explore

Use Case 1

⁠
Use case 1 - Time sheet / time balance sheet
⁠

⁠
Time sheet
⁠

⁠
Time sheet view by year, person, and week
⁠

⁠
Time balance sheet
⁠

⁠
Time balance sheet view by year and week
⁠

Description

Table 1

Time sheet
This table contains all worked hours “*Total week (hrs)” for each project “Project, internal work, absence” by week “Week starts on”, for each “Person”. For each project “Project, internal work, absence” there there is one row per person per week. This can be demonstrated in the view
Time sheet view by year, person, and week
⁠
.
See screenshot here
⁠
Table 1 View 1 Screenshot 2022-04-06 at 15.39.08.png
⁠
⁠

Table 2

Time balance sheet
This table has one row per week “Week starts on” and per person “Person”.
The column “*Worked hours” shall display the sum of the worked hours per week for each person from Table 1.
I use the following formular:
140.50
⁠
⁠
⁠
Formula Screenshot 2022-04-06 at 15.47.14.png
⁠
⁠
How must the formula be changed to filter the sum() for each week and person?
Please help!

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.