Projected Labor Needs & Labor Schedule

David Bramer

I have multiple tasks with various durations. At some point, most task's duration overlaps with another. I need to project out on any given day what my total labor needs would be for that day.

I have two sheets:

Sheet #1 - Labor Schedule

Sheet #2 - Projected Labor Needs

In the snip-it below (Top Part Clouded) I have manually inputted the numbers to show what they should be for each day due to the overlap in tasks.

Below that I have copied out the dates again and shown the formula I am using.

I am using this formula:

=SUMIFS({Labor Schedule Range 1}, {Labor Schedule Range 2,">=" + SWD@row, {Labor Schedule Range 3},"<=" + EWD@row))

I am getting an unparseable.

I would appreciate any help or service that could remedy this.

Paul Newcome

I missed a closing curly bracket that needs to be put in after the second range.

{Labor Schedule Range 2}

Paul Newcome

You don't have to concatenate the arguments to the criteria in Smartsheet. You also have 1 too many closing parenthesis on the end of the formula.

=SUMIFS({Labor Schedule Range 1}, {Labor Schedule Range 2, @cell >= SWD@row, {Labor Schedule Range 3}, @cell <= EWD@row)

David Bramer

Paul,

Thank you for the quick response. When I changed the formula it says invalid:

Paul Newcome

I missed a closing curly bracket that needs to be put in after the second range.

{Labor Schedule Range 2}

David Bramer

Paul,

You are awesome thank you! I just had to add the bracket and flip the greater than signs and it worked!

=SUMIFS({Labor Schedule Range 1}, {Labor Schedule Range 2}, @cell <= SWD@row, {Labor Schedule Range 3}, @cell >= EWD@row)

Do you know if its possible to exclude weekends from having labor needed?