Manpower Summation from Schedule

Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", "piping subcontractor" etc. My schedule is about 1500 lines long with lots of concurrent activities. My goal is to have a sheet for each "assigned to" subcontractor that sums manpower for every week of the project so I can forecast. For this data, I have a new sheet called "sheet metal subcontractor manpower" with 4 columns: Week #, Start Date (monday), End Date (friday), and manpower count. The manpower count is where I am having issues with the formula. My formula is below. Please help and thank you so much! Please let me know if there are any questions.

=SUMIFS({Monarch Schedule Range 1}manpower:manpower,[Start Date]@row:[End Date]@row,{Monarch Schedule Range 1}Sheet Metal Subcontractor,{Monarch Schedule Range 1}>0)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!