Forum

Notifications
Clear all

Automatically dividing an amount over X weeks

2 Posts
2 Users
0 Reactions
112 Views
(@blbates04)
Posts: 1
New Member
Topic starter
 

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.

 
Posted : 23/02/2019 5:47 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Brandy

There is no attachment.

 
Posted : 24/02/2019 1:51 am
Share: