How to use Index/collect for multiples criterias or is there any other functions that can be used

I want to collect story points based on key and status = done from another sheet. Currently, I am using this formula but it is working only for one criteria. When I am adding the other condition getting the error.

=IF(ISBLANK(Key@row), "", DISTINCT(COLLECT({Actual Epic Story Points}, {Unique Issue Key}, Key@row, {Actual Status}, "Done")))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for context?

sweta22

I want to collect the Story points based on "done" status and key.

Paul Newcome

And what would the expected output be?

sweta22

For TES-348, the story points will be 19 since its status is "Done". Items with the status "In Progress" should have their story points set to 0.

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.