How to output a list based off of a cell

ashlyn.trussel

Hi,

I have two columns on my source sheet with employee's names, whether they are a project lead or project team member. The project lead column will always have one employee, whilst the project team member will likely have many.

I want an output where something will be filtered based off of a cell. For example, on the new sheet I could type in Justin's name into an input cell and it would provide me with a list of all of the projects he is working on whether as a team lead or member. Is this possible?

Matt Lynn ACT

@ashlyn.trussel

Try something like:
=Join(collect({ProjectNameColumnRefHere},{NameColumnRefHere},NameInputCell@row),char(10))

This will collect the project names of any that have the entered name in that name column and put a char(10) separator between them. You could replace the char(10) with "," or something. Some people make that result column a multi select drop down and use the char(10) so that each project name would show up as a separate bubble.