Working to pull data in from four sheets to a master rollup sheet and keep getting an error

#incorrect argument set

=COUNTIFS({XXXX Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXX Liquid Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXXXX Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXXXXX Product Range 2}, Primary7, {Status}, <>"Complete")

I'm using a Smartsheet template and the formula was already in the sheet, I just am adding sheets to it. Any help would be appreciated.

Thanks

Heather

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are the ranges in each formula referencing the same sheet as the other ranges in the same formula? Basically... Are these cross sheet ranges

COUNTIFS({XXXX Assigned to}, Primary7, {Status}, <>"Complete")

All on the same sheet as each other? Same for the remaining COUNTIFS?

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.