Need to create a formula that returns multiple values


I need a formula that will return the values in green based on the information in the table.

I am pretty new to using complex formulas and I have watched 100+ videos on Join Collect - If Contains and I just can't get it to work. Any help would be appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!