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

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


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


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭


    =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?


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!