ContributionsMost RecentMost LikesSolutionsRe: Unable to Select Shared Field for Multi-Select Text Input Field Hi Mark, No, the source field, "Department", is just a simple text field. ------------------------------ Peter Ohashi ------------------------------ Unable to Select Shared Field for Multi-Select Text Input Field I have a table that consists of different department tags, such as HR, Operations, Research, etc. I have a separate table that has projects that get tagged to multiple departments. I want to create a multi-select text field that uses the "Department" text field in the other table as a source field. When I try this the pop-up opens and I am able to select the correct field, but when I click "Ok" the field does not update. The "Select shared field" option is now grayed out and when I try to save I get the following message: Any and all suggestions welcome! ------------------------------ Peter Ohashi ------------------------------ Re: Convert combined text email list to list user fieldHi Mark, My organization currently assigns employees to projects using a default user set (all employees on our QB environment). We were looking to have each of these fields be filtered down to only the relevant role. When selecting a user as the Project Manager, we'd like a filtered list to appear. We have achieved this by manually adding names to the custom list, but would like to automate the process so we do not have to continuously edit this list. We have a table of master users with assigned roles. I am able to create a combined text field with only the users in a specific department, but am struggling to convert this to a user list. I tried your method and found that it will only work on up to 20 users. Do you have any idea how to work around this? ------------------------------ Peter Ohashi ------------------------------