Hi there,
I am a Lead Producer at a Marketing Agency. We currently use Harvest to track teammates time on different Projects. I am currently building out a Notion for Project Management.
Currently, the flow of information is
Projects > Deliverables > Tasks
In that, there are several projects, each of them have their own set of deliverables, and each deliverable has a set of tasks associated with it.
I would like to automate a way, if possible, for someone to go into their Harvest account, track their time against a Deliverable they’re working on, and have that aggregate time populate into a “Actualized Hours” column of data associated with a Deliverable.
So, for example, let’s say I (Laura) am working on a Deliverable “Launch Packaging” and spend 1 hour today, 5 hours tomorrow, and 3 more on Monday working on that Deliverable. I’d track those 3 instances of time in Harvest, and then I or my Manager can go and see on Notion that overall I’ve spent 9 Actualized Hours working on Launch Packaging.
Ideally it’s a two way street, to avoid manual input: If I enter a deliverable into Notion, it’ll populate as a line item to Harvest that I can track against, and once I track hours to that line item, it populates back to a field on Notion.
Am I asking too much here? Can anyone help?