COLLECT not looking within multiselect criterion range
I'm using a combination of JOIN and COLLECT to get some data, but the COLLECT is only looking at the first value in my Multiselect column for the criterion range.
I have a sheet that lists value similar to below:
What I'm trying to do is have another sheet display it this way:
My current formula is only displaying it this way:
Help Article Resources
Check out the Formula Handbook template!