Hello all!
This is my first Coda community topic; excited to be here. I’m working on building a time-tracking system for my freelance work as a graphic designer. I want to account for different pricing methodologies in this system: charging by the hour, by the day, recurring retainer, fixed pricing, and value based pricing. Where I need help is getting the day rate to work.
Currently I have two tables: Time Tracker and Projects to store all my information. The time tracker allows me to “clock in” and “clock out” of a task, assign the task to to a project (in the Projects table), round the time spent on that task to the nearest 15 minute, and calculate the cost of my time based on an hourly rate that I set for that specific project (which happens in the Project table). That takes care of the hourly pricing methodology nicely and is working just fine. Now for the day rate. My thought process for setting this up was:
• I already am capturing a “start time” and “stop time” for my hourly work
• I can (and have already) set up an additional column called “Date” that identifies the date (without a time stamp) that a task occurred
• I need to be able able to sum unique dates and multiply that sum by my “Day rate” price in the Projects table.
That third bullet is where I’m stuck. What formula can I use to look at all the dates in my “Time Tracker” table, column “Date” and sum all unique dates? I’m providing an embed of a sandbox version of the doc I’m working in:
Link to doc: https://coda.io/d/Alices-sandbox_dVO2z3nkx0g
Happy to provide more detail and answer questions as needed! Also, for any other freelancers or folks who have built similar tables, I welcome any feedback/critique/advice about more efficient ways to set something like this up!
Cheers