How To Cross Reference Another Sheet and Return a Value if The Summary Column Matches

Hello!

The title may be confusing. I am looking for help in correcting a formula. I have two sheets. One is a live sheet that is connected to Jira and imports information about Jira cards. I have an automation set up to copy rows to another sheet (Jira Sprint History) if the is a value in the Sprint column. I'd now like to return that sprint value back to the original sheet in another column (Sprint History)

I've tried variations of the formula below and I keep getting column value errors. Does anything stand out?

=IFERROR(INDEX(COLLECT({Jira Sprint History Range 3}, {Jira Sprint History Range 2}, Summary@row ), COUNTIF({Jira Sprint History Range 2}, Summary@row ) - 1), "")

Find more posts tagged with

Accepted answers

Cassie L

@Bethany Norman See if this does the trick:

=IFERROR(INDEX(COLLECT({Sprint Column},{Summary Column},Summary@row ),COUNT(COLLECT({Sprint Column},{Summary Column},Summary@row ))),"")

Best,

Cassie

Source: Copilot

All comments

Cassie L

@Bethany Norman See if this does the trick:

=IFERROR(INDEX(COLLECT({Sprint Column},{Summary Column},Summary@row ),COUNT(COLLECT({Sprint Column},{Summary Column},Summary@row ))),"")

Best,

Cassie

Source: Copilot

Bethany Norman

YOU'RE AMAZING OH MY IT WORKED.

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.