Is there a formula to pull a task list based on assigned column?

Adam Joe

I would like to create a separate spreadsheet that pulls tasks assigned to people. For example 5 tasks are assigned to person A and I would like it to list out each task based on what is entered in the task column.

Person A: Task 1

Task 2

etc.

Is there any way to do this, thank you in advance.

Mark Cronk

Try:

=JOIN(COLLECT({Task column}, {names}, Name@row), char(10))

The sheet with this formula needs to have a Column [name] that is the same type as your assigned to person column. Enter names into it. The formula will collect the tasks assigned that person and display them on different lines in a single cell.

Work for you?

Mark