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

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @JakeAnderson

    I hope you're well and safe!

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi @Andrée Starå - I've added you to the smart sheets and added screen shots here. Thanks! For each of the "assigned to" fields, I want to sum up the manpower for a given range of dates (or by day if that is easier). Then pull this information into a dashboard and graph it so I can quickly forecast manpower.