Conditional lookup to create a list from a list


This seems like a very rudimentary ask but I am stumped. Hope someone can help.

Can anyone please suggest a column formula that can bring values over from a sheet based on a conditional lookup to an adjacent cell and list them contiguously on another sheet?

Like so:

Thanks in advance.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!