February 23, 2019
In one sheet I have all job information including an amount of board footage to build, number of weeks it will take to build it, and a start date. In the next sheet I have all upcoming weeks lined out across the columns and the jobs listed out by row. I need a formula that will look at the first sheet and take the amount of board footage and divide it by the amount of weeks it will take to build, then enter that amount in the build weeks. So if the start date is the week of March 4th and it will take 10 weeks, it will enter 1/10th of the total board footage starting on March 4th and the next 9 weeks. I've attached what I've currently got, but it's not very functional at all.