So I have an EnumLIst where I select multiple Employees emails from my employee data. The field is called [Task Assigned to]
The next field [EMPLOYEE PHONE NUMBERS] then looks at who’s on the list and looks up their phone numbers from the employee data page and outputs an enumlist with their phone numbers based on the employee data page. The question is how do I do this?
I have found a couple of different ways but I’m having trouble translating it to my needs: This is the post that seems to do what I need.
SPLIT(LOOKUP([_THISROW].[Project Key],Projects,Key,Project team)," , ")
Something like this would seem to be it but it’s not quite right.
SPLIT(LOOKUP([_THISROW].[Task Assigned to],“EMPLOYEE”, “companyemail”, “companyphone”) , ", ")