Evaluate multi-select field to determine multiple contacts

Hi all. I need help. I have a form where people can complete to be able to sign-up for newsletters around certain topics (screenshot 1 below are responses from form). From there, on another sheet, I want to identify the subscriber for each newsletter topic (screenshot #2 below). I think I have done this before using a Join(Collect or Index(Match with "HAS" - but despite searching the community and trying several formulas, I'm failing. Anyone have an idea?

On screenshot #2, Sally Smith and Jim Jones should be listed next to commercial and government affairs and Sally Smith should be the only one listed by Labor & Employment, Litigation, and Privacy.


Thank you in advance for your help (and ideas),

Jen






Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!