SUMIF(S) Not Working

Smartsheet community,

I am having trouble with adding up a column of hours based on who the task is assigned to. Ihave a metrics sheet to use to populate the dashboards i have created.

=SUMIFS({BI/BA Team Projects Range 8}, {BI/BA Team Projects Range 1}, Item89)

{BI/BA Team Projects Range 8}= the column the numbers are located in

{BI/BA Team Projects Range 1= Assigned to Column

Item89= the persons name in the metrics sheet.

It was working but now I am getting a circular reference error and I cannot figure out what went on.

Thank you in advance for any assistance.

Find more posts tagged with

Accepted answers

All comments

John Jonassen

Hi @Carl Vieira

It looks like you only have criterion that you would like to meet, so would SUMIF better serve you in this case?

What if you were to try:

=SUMIF({BI/BA Team Projects Range 1}, Item89, {BI/BA Team Projects Range 8})

Carl Vieira

@John Jonassen thank you for this but am still getting a #circularreference error message when I use your suggested re-write.

Carl Vieira

@John Jonassen I reformatted my formula in the metrics sheet I created and it worked great!

Thank you!

Mike Wilday

Hi Carl, here is some more information on Circular Reference:

https://help.smartsheet.com/articles/2476176-formula-error-messages#toc--circular-reference

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.