Issues with multiple Sumifs statements

I can't get this formula to work...any thoughts?

=SUMIFS([Hours/Week]:[Hours/Week],[X Project Status]:[X Project Status], "Active", [Assigned to]:[Assigned to], "Employee Name", Type:Type, <>"Admin") + SUMIFS([Hours/Week]:[Hours/Week],[Y Project Status]:[Y Project Status], "Active", [Assigned to]:[Assigned to], "Employee Name", Type:Type, <>"Admin")

Find more posts tagged with

Accepted answers

Christy Kooiman

I'm not sure what happened but I actually deleted my formula, got out of smartsheets copied it back in and it took it this time. Odd but it's working now.

All comments

Paul Newcome

Are you getting an error or the incorrect number?

Christy Kooiman

@Paul Newcome I'm getting #Unparsable

Paul Newcome

Can you provide a screenshot of the formula actually in the sheet (opened up as if you are about to edit it)?

Christy Kooiman

I'm not sure what happened but I actually deleted my formula, got out of smartsheets copied it back in and it took it this time. Odd but it's working now.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.