I need to create a sheet that dynamically displays all projects assigned to me from another sheet called "Project Request Intake & Validation."
Requirements:
- The sheet must update in real-time (if a project is removed from the source sheet, it should disappear from my sheet automatically)
- Each assigned project should appear in its own separate row
- I need to work directly in this sheet, so using a Report is not an option
- I cannot use a "Copy Row" automation because I need real-time synchronization, not one-time copies
Current Approach: I'm using this formula as a column formula:
=INDEX(COLLECT({Request_Name}, {Assigned_To}, CONTAINS("Sally Jo", @cell )), 1)
Problem: This formula only returns the first project assigned to me. I need it to return ALL projects assigned to me, with each project appearing in a separate row.
Question: How can I modify this approach to dynamically populate multiple rows based on all matching entries in the referenced sheet?
