How can I copy cells from another sheet with multiple instances of the Matched cell reference

I'm new to the community, hello!

Scenario: I have a source sheet with time entries for all resources and all projects. Project ID appears in all rows.

I want to copy rows with the same Project ID’s into individual sheets, by sheet reference.

I am familiar with “Index/Match”, but I do not know how to capture multiple instances, can anyone help?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!