Joining two columns together for rows that match criteria

edited 03/08/23 in Formulas and Functions


I have a sheet with many columns from which I want to pull [Data]2 and [Data]20, in this format: "Data2 (Data20), Data2 (Data20),..." from another sheet.

So far we have

=IF(ISBLANK([Source1]@row), "", JOIN(COLLECT({Data2}, {Data5}, CONTAINS([Source1]@row, @cell), {Major/Minor}, "Major"), ", "))

And get

Data2, Data2, Data2, ...

but we have no way to add the second part. Any solutions?

Appreciate any help! We are stumped on our end :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!