Google spreadsheets, filling one sheet with info from another?

Question

Google Sheets

Good afternoon, I wanted to know about the possibility of some actions in the table. I have three sheets, the first sheet contains all my clients. Depending on the status (contract concluded or not), I would like new columns to appear in the second or third sheet with the last name and data of the client when filling out the first sheet. Tried through the functions in the table itself, it turned out not very beautiful. Is there any way to do so?

Answer 1

Everything is simple. We take a column with clients
A:A
We take a column with statuses
B:B
We replace clients with empty values, if there is no contract, we use the "mass" formula ArrayFormula ()
ArrayFormula(ЕСЛИ(B:B="Заключен";A:A;""))
What happened - we expand by 90 degrees with the TRANSPOSE () function
=ТРАНСП(ArrayFormula(ЕСЛИ(B:B="Заключен";A:A;"")))
You can initially filter out empty lines, then it will turn out like this:
Table demo
Trick with turning into empty values ​​is needed so that the data does not move out if the status of clients changes.