Firstly I love airtable and it has provided a ton of solutions to our company.
I am having trouble solving this. I would like to know, how many projects were running concurrently on the same date.
So for example:
August 1, we had item A and item B going, on august 3 we started item C, and august 4 we started items D, E, and F. On Aug 5, we finished item A and Item C. I would like to see the data like this. Each one of these items will get a start date and an end date.
Aug 1: Item A and Item B (2)
Aug 2: Item A and Item B (2)
Aug 3: Item A, Item B, and Item C (3)
Aug 4: Item A, Item B, Item C, Item D, Item E, and Item F (6)
Aug 5: Item B, Item D, Item E and Item F (4)
I have been using WORKDAY_DIFF currently to count how many days these items ran for.
The end goal is I would like to divide an overhead cost to into each items depending on how many items are currently running
so using the same example
Aug 1: 2 1000/2 = 500
Aug 2: 2 1000/2 = 500
Aug 3: 3 1000/3 = 333
Aug 4: 7 1000/7 =142
Aug 5: 5 1000/5 = 200
Item A: ran through Aug 1 through Aug 4 (4) so it had a cost of 500 + 500 + 333 + 142 = 1475
Item B: ran through Aug 1 through Aug 5 (5) so it had a cost of 500 + 500 + 333 + 142 +200 = 1675
Item C: ran through Aug 3 through Aug 5 (5) so it had a cost of 333 + 142 +200 = 675
So this process would be on going. I would manually enter the items and start and finish dates.
Ok let me know whatever other info yall need. I am pretty new to formulas.