Projected Labor Needs & Labor Schedule

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.

Find more posts tagged with

Project Management

Scheduling

Multi-year projects

Accepted answers

Paul Newcome

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

{Labor Schedule Range 2}

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.