Skip to main content

Hi - 

 

I’m building a project and resource management AirTable for an agency. As a part of this I’d like to be able to show scoped hours against actual worked hours per person per project. As an agency that frequently has a variety of different people working on a variety of projects there has to be some flexibility built into this. 

 

Setting up a scoped hour table per project is simple. Having actual hours that the team enter in rollup  filter by project is easy. Having actual hours filter by person is easy. The issue is filtering by both teammate and project. 

 

Thank you for any help!

 

 

Does this look right?

The idea is to have a table where each record represents a single Person <> Project link, and you could create an automation that’ll create the links for you automatically, and I’ve set that up in a base here for you to check out!

 

I’ve built a couple of Project Management Bases and I’ve used a “Logs” table for collaborators to easily enter their Logs in a simple interface, which account for their worked hours. These are rolled up (summed) to calculate the total hours worked per project per collaborator.

Regarding the scoped hours, you could have that as a column in the Projects table, if you only scope for the entire project and do not divide the scoped hours per collaborators. If you want to have the scoped hours per collaborator as well you could save that in a new “Scopes” table or also in the Logs table and apply a Type single-select column to set “Scope” or “Log”.

Then to view hours scoped or worked per Project per Collaborator you can create a nice Dashboard in the interface layer.

Hey ​@LydiaB!

You can go with ​@TheTimeSavingCo’s suggestion, or you can just group your Hours/Hours Log table by Project first, and by Teammate second. In such way, under a grid view you’ll be able to see the total hours for the Project (main group) and the total hours from each Teammate on such project (sub-group).

For more information on grouping, you can check out this Article. 

Feel free to reach out if you need any help with your setup. I’d be happy to show you around.

Mike, Consultant @ Automatic Nation

​@TheTimeSavingCo 

 

Thanks for the detailed info. Your workflow makes sense and I really appreciate the base to check out! This really does the trick :) 

Terms & ConditionsAccessibility statement