Multi Row Formula - IF between dates and refer back to a specific row

Question

I have a list of workspaces:

- ID's that equal 22 are support episodes

- ID's between 23-30 are updates

This is my input:

I need to link the updates to the support episode based on the following conditions:

- Person ID to match

- Workspace ID != 22

- start date is => the start date of Workspace ID 22 row

I then want to add an additional column for Workspace Group to show the Workspace Ref is for all lines within the group.

My desired output is:

Can this be done with a Multi Row Formula?

RaphaelSilva · Accepted Answer

Please see sample workflow attached
On your sample data, there was an easier way to do it with less rules, as are expecting your data structure to change?
Because if it changes, is better to work on having the data on that structure before applying multirow formula, otherwise it might also not work in another sort order.