Hi! I work for a general contractor and I’m hoping to migrate to Coda full-time soon for all aspects of our project management and human resources.
I’ve managed to learn quite a bit by combing through these threads and working through a lot of trial and error with lots of different formulas, but this one in particular has me stumped.
I want to be able to open up a “Payroll Report” section each week in order to run payroll. I need this report to total up each employee’s hours by day (I’ve managed to do this). AND I’d like to be able to SUM each time entry per job site. I’ve created a dummy doc to give you an idea of what I’m trying to do:
The Payroll Report section gives an example of the table that I’m stuck with, including the formula I can’t seem to get right. And below that is an example of what I’d like that table to ultimately look like.
It’s important to me to be able to have the control filter functionality based on date at the top of the page, which is why I thought that a “View of” the Time Log table would work best, so I wouldn’t have to continually update the data.
It seems like something like this would be possible but I just can’t figure it out Thanks in advance for your help and your input!