Index Collect Question

I am trying to use Index Collect for the following - and I am stuck :-)

In the column "Validation NL" (upper table) I like to display the value of the column "Jira Status" if

the value in the column "Epic" = "GBT-704"
the value in the column "Req ID" matches the value in the column "MMP ID"

This is the formula I tried but it returns and #Incorrect Argument:

=INDEX({Jira MMP's Validation Results - Jira Status}, COLLECT("GBT-704", {Jira MMP's Validation Results - Epic}, [Req ID]@row, {Jira MMP's Validation Results - MMP ID}, 0))

This formula I tried and it returns #Unparseable

=INDEX(Collect({Jira MMP's Validation Results - Jira Status},{Jira MMP's Validation Results - Epic},"GBT-704"), Match([Req ID]@Row, {Jira MMP's Validation Results - MMP ID},0))

I am at the ends of my wits 🧐

Thank you for your ideas!

Find more posts tagged with

Formulas

Accepted answers

EvanShortreed

Hi Sylvia,

Go ahead and try this formula

=INDEX(COLLECT({Jira MMP's Validation Results - Jira Status}, {Jira MMP's Validation Results - Epic}, "GBT-704", {Jira MMP's Validation Results - MMP ID}, [Req ID]@row), 1)

All comments

EvanShortreed

Hi Sylvia,

Go ahead and try this formula

=INDEX(COLLECT({Jira MMP's Validation Results - Jira Status}, {Jira MMP's Validation Results - Epic}, "GBT-704", {Jira MMP's Validation Results - MMP ID}, [Req ID]@row), 1)

Sylvia Kay

Aww, thank you so much, but it also returns an error.

NicoLHC

@Sylvia Kay dis you resolve?

Paul Newcome

@Sylvia Kay Exactly what error message are you getting?

Sylvia Kay

Hi Paul, my mistake: The formula works! Thank you so very much!!!!

Sylvia Kay

MischeleSamson

Thank you soo much

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.