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

sweta22

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")))

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.