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
-
@Munir Sadiq this is not possible, please see this request to vote: Combine Contacts from multiple columns into a single cell — Smartsheet Community
-
IF your teams are static and you can group them in such a way that's multiselect, you could do a formula that returns contacts from one cell based on criteria to bring contacts over, but you cannot combine from multiple cells.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!