Hi all, I’m working on a personal time-tracking calculator for my freelance work. I’m using the table called “Deliverables” to average the amount of money I’ll earn from each deliverable. This happens by targeting the “Time tracker” table, filtering by the deliver that matches with the row in “Deliverables” and then summing the a column called “Hourly cost.”
What I’d like to be able to do, but can’t figure out how to write a formula for, is get that same calculation even when a single row in “Time tracker” has multiple deliverables in its “Deliverables” column. An example being, I’m spending 15 minutes adding in UPC codes to 3 different beer labels. I’d rather have one task called “Adding in UPC codes” and then split the time spent on that between the 3 deliverables, rather than have 3 separate rows for each one. The cost of that 15 minutes (which would be multiplied by an hourly rate set in the “projects” table) would need to be evenly divided betewen all 3 deliverables.
Eventually I’ll average these sums in the last table, “Deliverable types", so I can get a sense of how much I’ve charged past clients for things.
Originally I thought a formula like this applied to the “Total” column in the “Deliverables” table would do the trick, but I think I’m misunderstanding how
If([Time tracker].Deliverable.Contains(thisRowthisRow.[Deliverable name]),[Time tracker].[Hourly cost].Sum()/Count([Time tracker].Deliverable,""))
Open to all and any advice and suggestions!