Join Collect with multiple criteria

Michelle Lempert

Can someone help me with this formula? It will not work for the life of me.

=JOIN(COLLECT({Current Loans Range 5}, {Current Loans Range 1},

"CASA"), [{Current Loans Range 2}, "Y"]), "; ")

Michelle Lempert

I finally got it. I am not 100% sure what I changed after staring at this all day

=JOIN(COLLECT({Current Loans Range 5}, {Current Loans Range 1}, "CASA", {Current Loans Range 2}, "Y"), "; ")

Genevieve P.

Hi @Michelle Lempert

Looks good!

Seems like your first formula had a few extra brackets/parentheses that needed to be removed. I'm glad you figured it out 🙂