How can I pull all projects associated with one team member into separate rows?
I need a report that shows all projects each employee is associated with under the Team Member column from a multi-select list. Because of the multi-select, I can't run a report and group by Team Member.
My work-around was to create a separate sheet that would just pull every project name associated with the employee on a separate row and I would run the report from there. I found =Join(Collect but it groups the information by commas. Smartsheet doesn't have a text to columns option and with the comma list being 10+ projects long, I couldn't figure out any of the LEFT or FIND formulas to separate the values to separate rows.
I'm tagging you both as everything I've come across has your names on it with a solution.
Thanks for your help!
Help Article Resources
Check out the Formula Handbook template!