Cross Sheet JOIN/COLLECT/INDEX/MATCH conundrum.

Hi all, going a bit crazy trying multiple variants on these formulae to get my desired outcome. Hoping someone can put me out of my misery.

In my source sheet I have columns and rows like this:

In my destination sheet I want to pull in a list of Projects from the source sheet that are Flagged "Yes". Like so.

It seems so simple, and yet, I cannot compile a working formula.

Can anyone assist?

Thank you.

Jim

Find more posts tagged with

Formulas

Accepted answers

All comments

Brucey

Hey Jim,

I had a similar issue recently but I found a few workarounds.

You can create a report and use a filter to show only projects that are flagged as 'Yes'
You can create an automation that determines any projects flagged as 'Yes' get copied/ moved over to another sheet.

Is that helpful?

Jim B

Hi Brucey,

Thanks so much for your response. I'll use the automation option in this instance. I just didn't want to be defeated by what seemed like such a straightforward formula.

Thank you.

Jim

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.