Join Collect with multiple criteria

Options

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"]), "; ")

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!