Formula to join cells from a contact list column while maintaining the contact list type for filter

An example would be to have a "Team Sheet" that has a column for "Team Dept." and another column for "Team members" that is a contact list type.

In another sheet called the "Project Sheet," We'd have a column for the Project name, one for "Team Dept.," and then another for "Team Dept. Members." I'd like to use Team Dept to pull in the respective group members per row from the "Team Sheet." such that respective team members for each project could then filter their projects list accordingly.

Any thoughts? My testing has resulted in text strings that can't be filterable by the current user.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!