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 :)