Manpower Resource Loaded Schedule - SUMIFS Formula Help Needed

Hello, I have created a resource loaded schedule based on manpower in Smartsheets. I have a separate "Metrics Calculation" sheet where I am calculating the manpower per day and per department. However, I am having trouble performing the calculation using a SUMIFS function. Once this number is calculated, I want to roll this information up into a Dashboard. I eventually want to display this information in a Chart that shows manpower needs each month.

Please see the snips below of the Production Schedule and Metrics Table with Formula. The formula is as follows:

=SUMIFS({Manpower}, {Start Date}, @cell <= [Date_]@row, {Finish Date}, @cell >= [Date_]@row, {Project Department}, CONTAINS("Drafting", {Project Department}))

Essentially, in this formula, I am trying to add the number in the Manpower Column if the date listed is in between the start and finish date and if the Department in the "Project Department" column is "Drafting" (eventually I want to do this same calculation for the other Departments - CNC Cut, Fabrication, etc.). At this point, it keeps returning a 0 and not adding the numbers in the Manpower Column.

Thank you for your help.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!