Hi guys, I’m really new here and struggling to wrap my head around the different formulas and what not. So quick backstory is I’m a carpenter and I’m trying to set up a document to help me with my jobs, from quoting and purchase orders, to a schedule/gantt chart and a list of all the tasks involved in a renovation etc.
Here is my struggle:
I’ve made a task list of everything involved and have start dates, end dates and have assigned each task to the respective trade such as the carpenter, plumber, electrician etc.
What I am wanting to do is calculate the total number of days the carpenter will be on the job, but my issue is there are some tasks that I have assigned on the same day as other tasks. So there are multiple entries on the same day so I can’t just simply add the duration together.
What I was thinking was that I would have to write something (please excuse my coding language or lack thereof… this isn’t my profession) along the lines of:
Sum(Tasklist.trades=“Carpenter”.If(Tasklist.Start=MULTIPLE VALUES and Tasklist.End=MULTIPLE VALUES, Count(First(Duration()))))
Really hope that makes sense. I feel a bit out of my depth haha!
Thanks in advance!