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.




  • Brucey
    Brucey ✭✭✭✭✭

    Hey Jim,

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

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

    Is that helpful?

  • Jim B
    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!