I’m going to try to explain my problem in English (I’m French).. sorry for the mistakes.

Sheet1 list names of workers
Sheet3 list names of clients followed by names of the workers who worked with them.

Maybe this is a standard thing to do but I can’t figure it out without getting myself into a recursive pickle.

I’m trying to use FILTER to filter (obviously) a single row down to a subset of cells based on the contents of a different row of data. Using two FILTERs, I am able to produce two halves of the data I am seeking, but cannot figure out how to create the complete row outright using a single FILTER. Simply using HSTACK to append the two halves is no good, because I need the output data to remain in the same order as in the original.

In google sheet. I need a formula to split this a cell which contains a text divide by brackets. There are four values between these brackets. I need to separate these values in single cells:

Like in this simple example on Google Sheet I have a formula to create an official note we add on invoices in QuickBooks which is a concatenation of cells and words.

I have a value in one cell looking something like this:
(The product name and the amount required)

I am new to Google App Scripts. While running my first elementary App Script, i am denied access with the following error message:

I have a Google Spreadsheet file created by using the “task list” template. I have this file as a TO-DO list for quickly record my daily activities.

Link to Spreadsheet