Liero131313
New Member
- Joined
- Jun 9, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
Thank you very much for reading this.
Say I have some lumber costs. And I can say "It'll take $2000", split this way between task 4 and 5 and I can tell it will be $500 per month from months 4 to 7"
I can take this small example and eventually come to the bottom distribution at the end of the screenshot, where the costs zigzag down, drawing down the first task by that month then when it runs out, go to the next task.
This requires both tables to have the same sum for Material 1 to work. It feels like there's a formula that can take any 2 tables as input and do this "Gantt charting" zigzag, but I don't know how.
I want to layer in multiple materials to the same table, so I can put a filter on it and you can just see it show the costs over time and task. Any help would be appreciated.
Thank you very much for reading this.
Say I have some lumber costs. And I can say "It'll take $2000", split this way between task 4 and 5 and I can tell it will be $500 per month from months 4 to 7"
I can take this small example and eventually come to the bottom distribution at the end of the screenshot, where the costs zigzag down, drawing down the first task by that month then when it runs out, go to the next task.
This requires both tables to have the same sum for Material 1 to work. It feels like there's a formula that can take any 2 tables as input and do this "Gantt charting" zigzag, but I don't know how.
I want to layer in multiple materials to the same table, so I can put a filter on it and you can just see it show the costs over time and task. Any help would be appreciated.