Adding Numbers for Each Resource Formula

Good Day Smartsheet Community:

I am trying to reference Each Resource and the total number of Points they have in Each Sprint. For Example:

Ron has several tickets with various Points. I would like to add those in a another sheet for him using a formula with the following criteria:

Countif

Name is Ron

Sprint is 5

Collect his total Story Points

The Problem is I don't if I Use Count, Collect, or Sum to get this number for each resource.

Thanks

Find more posts tagged with

Accepted answers

Anthony Barthelemy

Figured it our Smartsheet Community. No Need to Respond:

=SUMIFS({Story Points}, {Assignee}, "Ron")

All comments

Anthony Barthelemy

I am trying various Formulas but receive incorrect:

=SUMIF({Story Points}, {Assignee}, "Ron")

Anthony Barthelemy

Figured it our Smartsheet Community. No Need to Respond:

=SUMIFS({Story Points}, {Assignee}, "Ron")

Genevieve P.

Hi @Ray B

I'm glad you figured it out! Thanks for posting your solution for us.

Cheers,

Genevieve

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.